How to load dynamic flat files using SAP BODS

[former_member225225]

Hi all,

We have a situation, where we receiving the data as flat files(.csv).

But the header(schema) is not constant.

How to load respective columns in flat file to respective columns in table dynamically matching using SAP BODS.

Please Suggest any work around for this.

Thanks,

Syam.

[former_member466847]

when you say that the header data is not constant, do you mean that the number of columns and the order changes?
Data Services can read in multiple files as long as the schemas are the same and the files are stored in the same folder location as seen the following documenations.

SAP Designer Guide Section : Reading mulitple flat files.

https://help.sap.com/viewer/ec06fadc50b64b6184f835e4f0e1f52f/latest/en-US/572e29b86d6d1014b3fc9283b0...

Section : Using a Variable in flatfile name

https://help.sap.com/viewer/e54136ab6a4a43e6a370265bf0a2d744/latest/en-US/572b20876d6d1014b3fc9283b0...

I have found a slightly older kba that may help you, but it will need to be tested.
KBA 1501490 - How to use a flat file with multiple record types as a source and target - Data Services / Data Integrator