topic mapping load for concatenated data in QlikView

mapping load for concatenated data

Wed, 07 Dec 2011 10:04:55 GMT

Dears,

can you help with this question?

I have two files concatenated and then want to use mapping load, however at the end applymap shows only the values mapped from the first concatenated file. Data from the second one is not visible.

Should I use mapping load differently to have the whole set of data after applymap?

//January - October 2011 data:

LOAD

trim(OBJNR) as Object_number,
date(date#(UDATE,'YYYYMMDD'),'DD.MM.YYYY') as [Rev. rec. date]
FROM

(ooxml, embedded labels, table is Sheet1);

// November 2011 data:

Concatenate load

trim(OBJNR) as Object_number,
date(date#(UDATE,'YYYYMMDD'),'DD.MM.YYYY') as [Rev. rec. date]
FROM

(ooxml, embedded labels, table is [20111205_081606_JCDS]);

mapping load
Object_number,
[Rev. rec. date]
resident JCDS;

This gives in applymap rev.rec. dates only from January -October 2011. Thanks in advance for help.

mapping load for concatenated data

Wed, 07 Dec 2011 21:56:35 GMT

Store the concatenated file as a QVD and then perform applymap resident.

Same issue with load file*.csv, store before you use applymap.

mapping load for concatenated data

stevedark — Wed, 07 Dec 2011 22:02:44 GMT

I notice that you don't have a drop there in your script at present, do you have all the values in the JCDS table after the load?

Is the Object Number unique across both tables? If the same object number exists in both sources the only the first entry will get picked up and used by the apply map statement - this will most likely be the earlier dates.

- Steve