topic Re: Error with Apply map and concatenate in QlikView

Error with Apply map and concatenate

Thu, 12 Nov 2015 20:08:06 GMT

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";

Re: Error with Apply map and concatenate

sunny_talwar — Thu, 12 Nov 2015 21:17:10 GMT

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";