topic Re: multiple column as single data field in QlikView https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346777#M414376 <HTML><HEAD></HEAD><BODY><P>go to enable transform step, navigate tab and select transpose</P></BODY></HTML> Fri, 09 Jun 2017 16:52:52 GMT tajmohamed30 2017-06-09T16:52:52Z multiple column as single data field https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346776#M414375 <HTML><HEAD></HEAD><BODY><P>I have crosstable format data like below.</P><P></P><P>john;trin;bayley;bruce;arthur;colin</P><P></P><P>How can i load it in qlikview as data and called the field header usernames</P><P></P><P></P><P>UserNames</P><P>John</P><P>Trin</P><P>bayley</P><P>bruce</P><P>arthur</P><P>colin</P></BODY></HTML> Fri, 09 Jun 2017 16:43:02 GMT https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346776#M414375 userid128223 2017-06-09T16:43:02Z Re: multiple column as single data field https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346777#M414376 <HTML><HEAD></HEAD><BODY><P>go to enable transform step, navigate tab and select transpose</P></BODY></HTML> Fri, 09 Jun 2017 16:52:52 GMT https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346777#M414376 tajmohamed30 2017-06-09T16:52:52Z Re: multiple column as single data field https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346778#M414377 <HTML><HEAD></HEAD><BODY><P>before doing this you can add a column name before first name</P></BODY></HTML> Fri, 09 Jun 2017 16:55:01 GMT https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346778#M414377 tajmohamed30 2017-06-09T16:55:01Z Re: multiple column as single data field https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346779#M414378 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>This will help:</P><P></P><P>LOAD SubField(x,';') as UserNames Inline</P><P>[x</P><P>john;trin;bayley;bruce;arthur;colin]</P></BODY></HTML> Fri, 09 Jun 2017 16:59:23 GMT https://community.qlik.com/t5/QlikView/multiple-column-as-single-data-field/m-p/1346779#M414378 Sergey_Shuklin 2017-06-09T16:59:23Z