topic Re: Problem while loading data with Common/Repeat Column Headers in QlikView https://community.qlik.com/t5/QlikView/Problem-while-loading-data-with-Common-Repeat-Column-Headers/m-p/1226#M794589 <HTML><HEAD></HEAD><BODY><P>Try to create the load-statement with the file-wizard. By excel-files as source identical columns will be incremented like:</P><P></P><P>Description1,</P><P>Description2,</P><P>...</P><P></P><P>I believe by text-files this feature isn't available but there you could use <STRONG>no labels</STRONG> instead of <STRONG>embedded labels</STRONG> within the file-format and could just pick the right column-number and rename them like you want.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 16 Jan 2018 12:36:43 GMT marcus_sommer 2018-01-16T12:36:43Z Problem while loading data with Common/Repeat Column Headers https://community.qlik.com/t5/QlikView/Problem-while-loading-data-with-Common-Repeat-Column-Headers/m-p/1225#M794588 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi Friends!</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">I am trying to upload an excel table with common (repeated) column headers (screen shot attached, the header name is 'Description'), but still unable to get correct data loaded in my file. These are the 2 things I have already done with out any success -</SPAN></P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><BR />1. Commenting the ones I don't need </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><SPAN style="font-size: 10pt;">2. Used the '</SPAN><SPAN style="font-size: 10pt; color: #0000ff;">as</SPAN><SPAN style="font-size: 10pt;">' statement to rename all of them</SPAN></SPAN></P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><SPAN style="font-size: 10pt;">Every time Qlikview is fetching data from the last 'Description' field, which I don't need. </SPAN>Appreciate</SPAN><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"> your help on the same guys!!!</SPAN></P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Aditya</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Problem-while-loading-data-with-Common-Repeat-Column-Headers/m-p/1225#M794588 sonu8072 2020-11-25T16:16:04Z Re: Problem while loading data with Common/Repeat Column Headers https://community.qlik.com/t5/QlikView/Problem-while-loading-data-with-Common-Repeat-Column-Headers/m-p/1226#M794589 <HTML><HEAD></HEAD><BODY><P>Try to create the load-statement with the file-wizard. By excel-files as source identical columns will be incremented like:</P><P></P><P>Description1,</P><P>Description2,</P><P>...</P><P></P><P>I believe by text-files this feature isn't available but there you could use <STRONG>no labels</STRONG> instead of <STRONG>embedded labels</STRONG> within the file-format and could just pick the right column-number and rename them like you want.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 16 Jan 2018 12:36:43 GMT https://community.qlik.com/t5/QlikView/Problem-while-loading-data-with-Common-Repeat-Column-Headers/m-p/1226#M794589 marcus_sommer 2018-01-16T12:36:43Z