Can I create a Mapping Table in Two Steps using Concatenate?

[#1]

Hi:

Is it possible to create a mapping table in two steps using the concatenate function?

Assuming that the Field A and Field C are the same kind of data and there is no duplicate.

For example:

MapExample:

MAPPING LOAD DISTINCT

     Field A,

     Field B,

Resident Table 1;

MapExample:

CONCATENATE

MAPPING LOAD DISTINCT

     Field C,

     Field D,

Resident Table 2;

Thank you very much.

PC

[#2]

OK.

I just tried and it said 'Illegal combination of prefix'.

Is there any way of doing this?

[eduardo_sommer]

you can concatenate Table1 and Table2 and do a mapping load after that, using the resulting table as the source.

Eduardo

[shawn-qv]

Concatenate Table1 and Table2 into a single table (i.e. Table3), and load the mapping table out of Table3.

Rename the fields from Table2 if you have to, so that you only end up with a 2-column mapping table (otherwise the mapping table will not load).

Table3:

load A, B resident Table1;

load

     C as A,

     D as B

resident Table2;

mappingTable:

mapping load * resident Table3;

drop table Table3;

S.

[PastusheniA]

https://qlikviewcookbook.com/2020/12/can-i-update-a-mapping-table/