Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(
// November 2011 data:
Concatenate load
trim(OBJNR) as Object_number,
date(date#(UDATE,'YYYYMMDD'),'DD.MM.YYYY') as [Rev. rec. date]
FROM
(
mapping load
This gives in applymap rev.rec. dates only from January -October 2011. Thanks in advance for help.
Store the concatenated file as a QVD and then perform applymap resident.
Same issue with load file*.csv, store before you use applymap.
Store the concatenated file as a QVD and then perform applymap resident.
Same issue with load file*.csv, store before you use applymap.
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