topic Re: Can I create a Mapping Table in Two Steps using Concatenate? in QlikView

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

Tue, 10 Jun 2014 02:45:55 GMT

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.

Tue, 10 Jun 2014 02:50:27 GMT

OK.

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

Is there any way of doing this?

eduardo_sommer — Tue, 10 Jun 2014 02:56:11 GMT

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

Eduardo

shawn-qv — Tue, 10 Jun 2014 04:58:31 GMT

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;

PastusheniA — Wed, 30 Mar 2022 11:21:09 GMT