Load multiple csv files using sap data intelligence

[#1]

Hi Team

we are trying to load mulitple csv files with same format present in azure container to snowflake using sap DI.

Structure file consumer operator doesn't allow wild card character *.csv

Please suggest the workflow and operators with which we can achieve this requirement.

Thanks,

Shubha

[ankitsharma_71]

Hi Shubha,

Below is one of the method that I have used to read multiple csv files with same format:

1. Use List File operator in the Graph, mention connection Id and Path of the file (Here don't mention the filename). There is one "Filter" Option in operator, in that select "With Regular expression" and enter filename like this - "Filecsv_".

2. Connect the output of ListFile with Input of Readfile operator and select Read(From Input) .

3. Execute the graph, and it will read all the files starting with name (Filecsv_) one by one.

Please let me know if you are able to find any other approach.

Thanks,

Ankit