I'm attempting to do the following:
- Load a manually defined map into QV from csv
- Apply map to a dataset
- Identify unmapped items
- Store the updated list of map items into csv (including the unmapped cases)
- Have a person edit the csv to patch the gaps (i.e. map the unmapped items)
- Back to step 1, so that with every reload the mapping list is more complete than the time before.
Problem I'm running into:
- For some reason after the load (of a previously stored file), the first column name is prefixed with a set of special characters.
- I've tried specifying the character set, but that can only be done on the Load not on the Store, and I can't seem to find info on the default codepage for the Store operation.
- I know I'm fudging things by mixing csv and txt, but my options here appear very limited.
The two code lines pertinent to my question:
- Store OwnerLookup into $(vSharePath)APPS\OwnerLookup .csv(txt);
- LOAD * from $(vSharePath)APPS\OwnerLookup .csv (txt, delimiter is ',', embedded labels)
