Hello Community,
I hope all is well. Could you please try to help me, my script runs well but the data in not correct comparing with the data in the database.
I used apply map because I have to map the LB and LBopex fields from the 'Table_Correspondance'
the result in one table that contains LB and the corresponding LBopex , I used a left join to also map the opex category with the LBopew in the same table
The amout in QV is superior to the amout in the database.
Could you assist me please.
My script is bellow :
maptable:
Mapping
LOAD trim (lower([LB / ERP]))as LB,
trim(lower([LB / Budget]))as LBopex
FROM
[xx]
(ooxml, embedded labels, table is Table_Correspondance);
NoConcatenate
DA_BC:
LOAD *,
Replace( LB,' ' ,'') as LB2,
Date(PO_APPROVED_DATE, 'DD/MM/YYYY')as Date_PO,
SEGMENT2 AS CDR ;
SELECT *
from *****
WHERE ****
;
Concatenate
LOAD *,
Replace( LB,' ' ,'') as LB2,
date(CANCEL_DATE, 'DD/MM/YYYY') as Date_PO,
SEGMENT2 AS CDR ;
SELECT *
from
WHERE
;
drop field LB FROM DA_BC;
NoConcatenate
SUIVI_DA_BC:
LOAD *,
trim(lower(LB2)) as LB,
AutoNumber( MakeDate( year(date([Date_PO],'DD/MM/YYYY')), Month(date([Date_PO],'DD/MM/YYYY')), day(date([Date_PO],'DD/MM/YYYY')) ) , '%Date ID') as [%Date ID]
Resident DA_BC;
NoConcatenate
F_DA_BC:
load *,
ApplyMap('maptable',LB) as LBopex
resident SUIVI_DA_BC;
DROP Table DA_BC;
DROP Table SUIVI_DA_BC;
NoConcatenate
F2_DA_BC:
load *
resident F_DA_BC;
drop table F_DA_BC;
drop field LB2 from F2_DA_BC;
left join (F2_DA_BC)
mapt:
LOAD
trim(lower([LB / Budget] ))as LBopex,
OpEx_Category,
trim(lower([LB / ERP])) as LB
FROM
[---]
(ooxml, embedded labels, table is Table_Correspondance);
