topic How to combine two fields in load script ? in QlikView https://community.qlik.com/t5/QlikView/How-to-combine-two-fields-in-load-script/m-p/1565414#M741490 <P>Hello,&nbsp;</P><P>I have two fields from the same table as shown below;&nbsp;</P><TABLE><TBODY><TR><TD><STRONG><U>Manager</U></STRONG></TD></TR><TR><TD>Stillman</TD></TR><TR><TD>George</TD></TR><TR><TD>Adam</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG><U>Developers</U></STRONG></TD></TR><TR><TD>Alex</TD></TR><TR><TD>John</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How to join two fields in the load script as shown below to get new field Employee?&nbsp;</P><TABLE><TBODY><TR><TD><STRONG><U>Employee</U></STRONG></TD></TR><TR><TD>Stillman</TD></TR><TR><TD>George</TD></TR><TR><TD>Adam</TD></TR><TR><TD>Alex</TD></TR><TR><TD>John</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>thanks</P> Sat, 16 Nov 2024 03:56:58 GMT bhaveshp90 2024-11-16T03:56:58Z How to combine two fields in load script ? https://community.qlik.com/t5/QlikView/How-to-combine-two-fields-in-load-script/m-p/1565414#M741490 <P>Hello,&nbsp;</P><P>I have two fields from the same table as shown below;&nbsp;</P><TABLE><TBODY><TR><TD><STRONG><U>Manager</U></STRONG></TD></TR><TR><TD>Stillman</TD></TR><TR><TD>George</TD></TR><TR><TD>Adam</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG><U>Developers</U></STRONG></TD></TR><TR><TD>Alex</TD></TR><TR><TD>John</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How to join two fields in the load script as shown below to get new field Employee?&nbsp;</P><TABLE><TBODY><TR><TD><STRONG><U>Employee</U></STRONG></TD></TR><TR><TD>Stillman</TD></TR><TR><TD>George</TD></TR><TR><TD>Adam</TD></TR><TR><TD>Alex</TD></TR><TR><TD>John</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>thanks</P> Sat, 16 Nov 2024 03:56:58 GMT https://community.qlik.com/t5/QlikView/How-to-combine-two-fields-in-load-script/m-p/1565414#M741490 bhaveshp90 2024-11-16T03:56:58Z Re: How to combine two fields in load script ? https://community.qlik.com/t5/QlikView/How-to-combine-two-fields-in-load-script/m-p/1565423#M741491 it is possible to resident load and create a table like that<BR />e.g.<BR />load distinct Manager as Employee<BR />resident YourFACT;<BR />concatenate<BR />load distinct Developer as Employee<BR />resident YourFACT;<BR /><BR />but bigger question is how it impacts your data model.<BR /> Thu, 04 Apr 2019 19:37:27 GMT https://community.qlik.com/t5/QlikView/How-to-combine-two-fields-in-load-script/m-p/1565423#M741491 dplr-rn 2019-04-04T19:37:27Z