topic Re: Combine two fields from same table and create new field. in QlikView

Combine two fields from same table and create new field.

karan_kn — Thu, 14 Mar 2019 18:27:54 GMT

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 — Thu, 14 Mar 2019 18:41:06 GMT

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!!!!