Delimited file Import and normalization
Hi everyone, I need to set up a few transformations to normalize a delimited file that will be uploaded by the users, before feeding it to the datasource. I previously worked with FTP folders, and...
Forum Discussion
You can use a matrix format data source and add multiple Account columns (search for Matrix Data Load for more info). The Golfstream app has a few examples (HoustonBudget). Alternatively you can use the TransformationEventHandler Business Rule to intercept the selected file and restructure it. I would go with the matrix format.