Ignore values when importing from CSV
I am running an API_ImportFromCSV command: <qdbapi> <usertoken> EXCLUDED </usertoken> <records_csv> <![CDATA[ %RepeatOn% [Location Code.csv],[Location Description.csv] %RepeatOff% ...
Forum Discussion
My mistake.
I thinking of two options, one with code, the other native, but more manual.
(1) Use script to pull missing Locations, and combine the 'like' values prior to import
or
(2) Create a summary report with the rows being grouped by Location code. Thus only getting unique values. Then export that report as csv, and then import to the Location Code table.
I thinking of two options, one with code, the other native, but more manual.
(1) Use script to pull missing Locations, and combine the 'like' values prior to import
or
(2) Create a summary report with the rows being grouped by Location code. Thus only getting unique values. Then export that report as csv, and then import to the Location Code table.