Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Error with Apply map and concatenate

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

1 Reply

Re: Error with Apply map and concatenate

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



Community Browser