How can we read dynamic CSV file using stage file activity in ICS
SummaryThe CSV file we receive from application can be dynamic as few columns may be missing. How to read this file correctly.
Even if few columns are missing in CSV it does read the file but file data is getting manipulated. Attached below sample as how it is reading file data incorrectly.
After deleting VendorCode4 and VendorCode5 from file attachment which is uploaded and received by ICS.
The file read response from ICS is incorrect.