combination of fields

[QSense]

Hello ,

I have two fields and I want to combine these in one field

for instance

ID                         ID1

100                       101

102                         103

I wanna new field including both two fields but it must be unique            

[sivarajs]

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

ID,ID1

100,101

102,103

];