Import Set Row not populating data from CSV files
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
I am Facing an issue when processing the Integration.
Setup:
Run Nightly Job which will load data from SFTP CSV to target table.
- Created Source table
- Created Staging table manually.
- Created Transform Map.(around 30 fields, out of those 20 are direct mapping and 10 are generated through calculation using source script)
- Created Data Source
- Attached the Transform Map to Data Source
- Created Scheduled Data Import and attached the data source to this.
Issue:
Recently, the CSV file added a new column which we had not defined in transform map.
Rest all fields are same, delimiter is same. when the nightly job is executed, it runs creating an import set and the import set rows are not populated correctly, it causes the OnBefore script to ignore the row and the data is not processed.
I am trying to debug this and not able to get to the root cause of how to address this, any suggestions how we can fix it ?
0 REPLIES 0
