topic Re: Assigning All Fields to a single Variable in QlikView https://community.qlik.com/t5/QlikView/Assigning-All-Fields-to-a-single-Variable/m-p/579927#M215527 <HTML><HEAD></HEAD><BODY><P>Try this,</P><P></P><P><STRONG><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;">&nbsp; </STRONG></STRONG></STRONG></P><P>Let <STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">var </EM></STRONG></EM></STRONG><SPAN style="font-size: 8pt;">= 'Country,Metric,Age';<BR /></SPAN></P><P><SPAN style="font-size: 8pt;">test:<BR /></SPAN><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;">LOAD</STRONG></STRONG><SPAN style="font-size: 8pt;"> </SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(var)</EM></STRONG></EM></STRONG></P><P><SPAN style="color: #0000ff; font-size: 8pt;">FROM </SPAN><SPAN style="font-size: 8pt;">test.xlsx; </SPAN></P><P> </P><P> </P></BODY></HTML> Wed, 30 Apr 2014 08:37:08 GMT 2014-04-30T08:37:08Z Assigning All Fields to a single Variable https://community.qlik.com/t5/QlikView/Assigning-All-Fields-to-a-single-Variable/m-p/579926#M215526 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>how to assign all fields from a table to a single Variable.</P><P></P><P>Ex:</P><P>Load $(Variablename)</P><P>from....abc.;</P><P></P><P>can anyone help me out.</P><P></P><P>Thanks in advance!!!</P><P></P><P></P><P>Regards,</P><P>Rathnam.</P></BODY></HTML> Wed, 30 Apr 2014 08:15:44 GMT https://community.qlik.com/t5/QlikView/Assigning-All-Fields-to-a-single-Variable/m-p/579926#M215526 rathnam_qv 2014-04-30T08:15:44Z Re: Assigning All Fields to a single Variable https://community.qlik.com/t5/QlikView/Assigning-All-Fields-to-a-single-Variable/m-p/579927#M215527 <HTML><HEAD></HEAD><BODY><P>Try this,</P><P></P><P><STRONG><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;">&nbsp; </STRONG></STRONG></STRONG></P><P>Let <STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">var </EM></STRONG></EM></STRONG><SPAN style="font-size: 8pt;">= 'Country,Metric,Age';<BR /></SPAN></P><P><SPAN style="font-size: 8pt;">test:<BR /></SPAN><STRONG style="color: #0000ff; font-size: 8pt;"><STRONG style="color: #0000ff; font-size: 8pt;">LOAD</STRONG></STRONG><SPAN style="font-size: 8pt;"> </SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(var)</EM></STRONG></EM></STRONG></P><P><SPAN style="color: #0000ff; font-size: 8pt;">FROM </SPAN><SPAN style="font-size: 8pt;">test.xlsx; </SPAN></P><P> </P><P> </P></BODY></HTML> Wed, 30 Apr 2014 08:37:08 GMT https://community.qlik.com/t5/QlikView/Assigning-All-Fields-to-a-single-Variable/m-p/579927#M215527 2014-04-30T08:37:08Z