topic Autogenerate field names in QlikView https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304863#M406261 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is it possible to generate field names within the Qlikview script?</P><P>Currently, I have 2 fields: Store and Detail.</P><P></P><P>What I would like to do is generate more detail fields based on if a store has multiple "Detail" rows</P><P></P><P>For example, I'd like a generate something like this:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Detail</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Detail2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Detail3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Detail4</STRONG></TH></TR><TR><TD>StoreA</TD><TD>Detail1</TD><TD>Detail2</TD><TD>Detail3</TD><TD>Detail4</TD></TR><TR><TD style="padding: 2px;">StoreA</TD><TD style="padding: 2px;">Detail2</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">StoreA</TD><TD style="padding: 2px;">Detail3</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">StoreA</TD><TD style="padding: 2px;">Detail4</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD></TR><TR><TD>StoreB</TD><TD>Detail1</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>StoreC</TD><TD>Detail1</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>StoreC</TD><TD>Detail1</TD><TD>Detail2</TD><TD>-</TD><TD>-</TD></TR><TR><TD>StoreC</TD><TD>Detail2</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR></TBODY></TABLE><P></P><P>Is this possible?</P><P></P><P>Thank you in advance</P></BODY></HTML> Fri, 02 Jun 2017 14:59:42 GMT Anonymous 2017-06-02T14:59:42Z Autogenerate field names https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304863#M406261 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is it possible to generate field names within the Qlikview script?</P><P>Currently, I have 2 fields: Store and Detail.</P><P></P><P>What I would like to do is generate more detail fields based on if a store has multiple "Detail" rows</P><P></P><P>For example, I'd like a generate something like this:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Store</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Detail</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Detail2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Detail3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Detail4</STRONG></TH></TR><TR><TD>StoreA</TD><TD>Detail1</TD><TD>Detail2</TD><TD>Detail3</TD><TD>Detail4</TD></TR><TR><TD style="padding: 2px;">StoreA</TD><TD style="padding: 2px;">Detail2</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">StoreA</TD><TD style="padding: 2px;">Detail3</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD></TR><TR><TD style="padding: 2px;">StoreA</TD><TD style="padding: 2px;">Detail4</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">-</TD></TR><TR><TD>StoreB</TD><TD>Detail1</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>StoreC</TD><TD>Detail1</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>StoreC</TD><TD>Detail1</TD><TD>Detail2</TD><TD>-</TD><TD>-</TD></TR><TR><TD>StoreC</TD><TD>Detail2</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR></TBODY></TABLE><P></P><P>Is this possible?</P><P></P><P>Thank you in advance</P></BODY></HTML> Fri, 02 Jun 2017 14:59:42 GMT https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304863#M406261 Anonymous 2017-06-02T14:59:42Z Re: Autogenerate field names https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304864#M406262 <HTML><HEAD></HEAD><BODY><P>Yes.</P><P></P><P>See GENERIC LOAD, explained here by HIC: <A href="https://community.qlik.com/qlik-blogpost/3629">The Generic Load</A></P></BODY></HTML> Fri, 02 Jun 2017 15:11:46 GMT https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304864#M406262 Peter_Cammaert 2017-06-02T15:11:46Z Re: Autogenerate field names https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304865#M406263 <HTML><HEAD></HEAD><BODY><P>How would I know detail1 is really detail1? what are the actual values in Detail field?</P></BODY></HTML> Fri, 02 Jun 2017 16:55:59 GMT https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304865#M406263 Kushal_Chawda 2017-06-02T16:55:59Z Re: Autogenerate field names https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304866#M406264 <HTML><HEAD></HEAD><BODY><P>This works! Thank you!</P></BODY></HTML> Fri, 02 Jun 2017 19:23:28 GMT https://community.qlik.com/t5/QlikView/Autogenerate-field-names/m-p/1304866#M406264 Anonymous 2017-06-02T19:23:28Z