Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

join two fields in same table

join.png

I have two fields in same table I want to put two fields values in one column

2 Replies
sivarajs
Specialist II
Specialist II

Try the example below

LOAD * , SubField(ID&','&ID1,',') as New_field Inline [

ID,ID1

100,101

102,103

];

Not applicable

Hi,

U can write a script like,

Load *

          ,UniteAdiG1&'#'&UniteAdiG2 as NewField

From SomeTable;

Regards,

Kabilan K