topic Re: Column header name changes every week - Can I automate load? in QlikView https://community.qlik.com/t5/QlikView/Column-header-name-changes-every-week-Can-I-automate-load/m-p/674931#M1061127 <HTML><HEAD></HEAD><BODY><P>Have a look at the Crossfield () functionality.</P></BODY></HTML> Tue, 23 Sep 2014 16:22:14 GMT simondachstr 2014-09-23T16:22:14Z Column header name changes every week - Can I automate load? https://community.qlik.com/t5/QlikView/Column-header-name-changes-every-week-Can-I-automate-load/m-p/674930#M1061126 <HTML><HEAD></HEAD><BODY><P>Dear QV community.</P><P>I would be grateful if someone could help me with the following issue.</P><P>I weekly receive and analyze forecast.</P><P>The structure is basically as follows.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 320px;"><TBODY><TR><TD colspan="2" height="21" width="160">file.xls (past week)</TD></TR><TR><TD class="xl63" height="21">item</TD><TD class="xl63" style="border-left: none;"><STRONG>week 15</STRONG></TD><TD class="xl63" style="border-left: none;">week 16</TD><TD class="xl63" style="border-left: none;">week17</TD></TR><TR><TD colspan="2" height="21">file.xls (this week)</TD></TR><TR><TD class="xl63" height="21">item</TD><TD class="xl63" style="border-left: none;"><STRONG>week 16</STRONG></TD><TD class="xl63" style="border-left: none;">week 17</TD><TD class="xl63" style="border-left: none;">week18</TD></TR></TBODY></TABLE><P></P><P>The situation is that each week the week number changes (it is increased in one).</P><P>I can edit the script, in order to adapt the app to this change, but I’d prefer to do this automatically.</P><P>Is there any way to “name” the fields during Load? Structure is the same, the only change is the column header name.</P><P>Thank you in advance for your help.</P><P>Leonardo</P></BODY></HTML> Tue, 23 Sep 2014 16:17:43 GMT https://community.qlik.com/t5/QlikView/Column-header-name-changes-every-week-Can-I-automate-load/m-p/674930#M1061126 2014-09-23T16:17:43Z Re: Column header name changes every week - Can I automate load? https://community.qlik.com/t5/QlikView/Column-header-name-changes-every-week-Can-I-automate-load/m-p/674931#M1061127 <HTML><HEAD></HEAD><BODY><P>Have a look at the Crossfield () functionality.</P></BODY></HTML> Tue, 23 Sep 2014 16:22:14 GMT https://community.qlik.com/t5/QlikView/Column-header-name-changes-every-week-Can-I-automate-load/m-p/674931#M1061127 simondachstr 2014-09-23T16:22:14Z