Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In Qlik somehow the leading zero's are removed while uploading. I thought it was fixed in the code. However I still see no leading zero's in my dataset. When the "000" is added in the join (see bold in code below or yellow in attachment). Which means the join is still not working correctly? See data table issue further below in message or see attachment. How to fix this?
tmp_C8:
LOAD
"Item Trading Code" & '|' & "Color Code" as %ItemColor_GlobalId,
"Item Trading Code" & '|' & "Color Code" as ItemColor_GlobalId_C8,
'FT' as _indSection,
*
Concatenate( tmp_C8 )
LOAD
"Item Trading Code" & '|' & "Color Code" as %ItemColor_GlobalId,
"Item Trading Code" & '|' & "Color Code" as ItemColor_GlobalId_C8,
'APP' as _indSection,
*
Qualify *;
Unqualify '%*';
Unqualify '_*';
NoConcatenate
C8:
Load
*
Resident tmp_C8
;
Drop table tmp_C8;
Outer Join( C8 )
Infa:
LOAD
"Trading Code" & '|' & "Color Code" as %ItemColor_GlobalId,
"Trading Code" & '|' & "Color Code" as ItemColor_GlobalId_Infa,
Date(Date#("Regional Retail Introduction Date", 'DD/MM/YYYY'),'MM/DD/YYYY') as RegionalRetailIntroductionDate,
*
Outer Join( C8 )
PPT:
LOAD
"Trading code" & '|' & Num( "Color" , '000' ) as %ItemColor_GlobalId,
"Trading code" & '|' & "Color" as ItemColor_GlobalId_PPT,
*
Outer Join( C8 )
SAP:
LOAD
"Item ID" & '|' & Num( "Color" , '000' ) as %ItemColor_GlobalId,
"Item ID" & '|' & "Color" as ItemColor_GlobalId_SAP,
If(num#([MovAv.4200],'#,00')<>0 AND num#("LSRP-4000",'#,00')<>0 AND trim([MovAv.4200]) & ''<>'' AND ("LSRP-4000")<>0 AND ([MovAv.4200])<>0 AND len(trim(Theme))*len(trim(MovAv.4200))*len(trim("CoO(Purcha"))*len(trim("LSRP-4000")), 'Ready', 'Not ready') as SAPSFMSstatusSalesorder,
*
See here the data
