Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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!!!!
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!!!!