Combine two fields from same table and create new field.

[karan_kn]

Combine ID1 and ID 2 create new field ID.  Please refer the screenshot below

LOAD * INLINE [
ID1, ID2, Text
11, 1, dsfsdf
, 2, sdgfd
13, 3, ertert
14, 4, hgjghj
15, 5, uiuyi
, 6, rwerd
17, 7, fdfgh
];

[Marcos_rv · Accepted solution]

Try this:

FINAL_TABLE:
load
if( (isnull (ID1)) OR (LEN(TRIM(ID1)) = 0) , ID2, ID1) AS ID,
Text;

LOAD * INLINE [
ID1, ID2, Text
11, 1, dsfsdf
, 2, sdgfd
13, 3, ertert
14, 4, hgjghj
15, 5, uiuyi
, 6, rwerd
17, 7, fdfgh
];

saludos!!!!