https://community.qlik.com/t5/QlikView/Reopening-a-csv-stored-by-QlikView/m-p/1866671#M1216352 <P>I'm attempting to do the following:</P> <OL> <LI>Load a manually defined map into QV from csv</LI> <LI>Apply map to a dataset</LI> <LI>Identify unmapped items</LI> <LI>Store the updated list of map items into csv (including the unmapped cases)</LI> <LI>Have a person edit the csv to patch the gaps (i.e. map the unmapped items)</LI> <LI>Back to step 1, so that with every reload the mapping list is more complete than the time before.</LI> </OL> <P>Problem I'm running into:</P> <UL> <LI>For some reason after the load (of a previously stored file), the first column name is prefixed with a set of special characters.</LI> <LI>I've tried specifying the character set, but that can only be done on the Load not on the Store,&nbsp; and I can't seem to find info on the default codepage for the Store operation.</LI> <LI>I know I'm fudging things by mixing csv and txt, but my options here appear very limited.</LI> </UL> <P>The two code lines pertinent to my question:</P> <UL> <LI>Store OwnerLookup into $(vSharePath)APPS\OwnerLookup .csv(txt);</LI> <LI>LOAD * from $(vSharePath)APPS\OwnerLookup .csv (txt, delimiter is ',', embedded labels)</LI> </UL> Fri, 03 Dec 2021 18:54:23 GMT jwaligora 2021-12-03T18:54:23Z https://community.qlik.com/t5/QlikView/Reopening-a-csv-stored-by-QlikView/m-p/1866671#M1216352 <P>I'm attempting to do the following:</P> <OL> <LI>Load a manually defined map into QV from csv</LI> <LI>Apply map to a dataset</LI> <LI>Identify unmapped items</LI> <LI>Store the updated list of map items into csv (including the unmapped cases)</LI> <LI>Have a person edit the csv to patch the gaps (i.e. map the unmapped items)</LI> <LI>Back to step 1, so that with every reload the mapping list is more complete than the time before.</LI> </OL> <P>Problem I'm running into:</P> <UL> <LI>For some reason after the load (of a previously stored file), the first column name is prefixed with a set of special characters.</LI> <LI>I've tried specifying the character set, but that can only be done on the Load not on the Store,&nbsp; and I can't seem to find info on the default codepage for the Store operation.</LI> <LI>I know I'm fudging things by mixing csv and txt, but my options here appear very limited.</LI> </UL> <P>The two code lines pertinent to my question:</P> <UL> <LI>Store OwnerLookup into $(vSharePath)APPS\OwnerLookup .csv(txt);</LI> <LI>LOAD * from $(vSharePath)APPS\OwnerLookup .csv (txt, delimiter is ',', embedded labels)</LI> </UL> Fri, 03 Dec 2021 18:54:23 GMT https://community.qlik.com/t5/QlikView/Reopening-a-csv-stored-by-QlikView/m-p/1866671#M1216352 jwaligora 2021-12-03T18:54:23Z