join two fields in same table

[QSense]

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

[sivarajs]

Try the example below

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

ID,ID1

100,101

102,103

];

[#3]

Hi,

U can write a script like,

Load *

          ,UniteAdiG1&'#'&UniteAdiG2 as NewField

From SomeTable;

Regards,

Kabilan K