Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to do Applymap with a table that it's concatenated with another. Is it possible? how can i do?
(I need to concatenate WID with table2, and I need to do applymap with WID and SID in Table1)
Thank you!
Table1:
LOAD Type_T AS Type_T_D99,
EM as EM_D,
SID,
ApplyMap('Table2',SID_D99,'Desconocido') as WID_K99;
SQL SELECT *
FROM "BD1.1";
Table2:
mapping LOAD SID as SID_D99,
WID as WID_K99;
SQL SELECT *
FROM "BD1.2";
concatenate(Table2)
LOAD WID as WID_K99;
SQL SELECT *
FROM "BD1.3";
May be this:
Table2:
LOAD SID as SID_D99,
WID as WID_K99;
SQL SELECT *
FROM "BD1.2";
Concatenate(Table2)
LOAD SID_D99 //you need this field as well, other wise the WID_K99 won't be mapped
WID as WID_K99;
SQL SELECT *
FROM "BD1.3";
Table3:
Mapping
LOAD SID_D99,
WID_K99
Resident Table2;
DROP Table Table2;
Table1:
LOAD Type_T AS Type_T_D99,
EM as EM_D,
SID,
ApplyMap('Table3',SID_D99,'Desconocido') as WID_K99;
SQL SELECT *
FROM "BD1.1";