CSV Import - Skip Columns on Update Duplicates

Hi Ryandoc,

The CSV Import plugin allows you to skip columns entirely, but I don't think it's readily possible to change these between updated/inserted records in the same import job. Likely the easiest way to achieve this would be to manually process the CSV file first and split it into two files - one of the duplicate records, and one of the new. This would give you better granularity for which columns to skip in the column mapping options. We can also keep this feature in mind for future iterations of the plugin.

Let me know if you have any questions!

Thanks,

Daniel
Technical Lead
interactivetools.com

By Ryan - September 11, 2019

Hi Daniel, we receive the data combined and it's uploaded via a RPA Bot process. We might be able to split the CSV data and carryout 2 uploads though. I'll try that approach.  

Thanks,
Ryan