Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can someone explain the below code.
WBS_Des_MAP:
Mapping
LOAD ID as WBS_Element,
if(WildMatch([FINAL WBS],'*-'),Replace([FINAL WBS],'-',''),[FINAL WBS]) as WBS_Element_Des
FROM
[..\10_data_sources\Excel\WBS MASTER-FINAL-CASHFLOW.xlsx]
(ooxml, embedded labels, table is DETAILS);
WBS_Des_MAP2:
LOAD
[FINAL WBS],
F3
(ooxml, embedded labels, table is [GROUP DESCR]);
WBS_Group_Des:
[FINAL WBS] as WBS_Code,
F3,
Descr
AssignmentToWBSMap:
LOAD Co.code,
if(len(trim([WBS Element]))>0,[WBS Element],
if(Len(Assignment)>=6,Assignment,H.Text)) as WBS_Code_Final
[..\10_data_sources\Excel\cashflow-*.csv]
(txt, codepage is 1252, embedded labels, delimiter is '\t', no quotes, no
eof);
'Current' as Cashflow_Period_Type,
if(ApplyMap('WBS_Des_MAP', [WBS Element],0)<>0, [WBS Element],
if(ApplyMap('WBS_Des_MAP',Assignment,0)<>0,Assignment,
if(ApplyMap('WBS_Des_MAP', H.Text,0)<>0, H.Text,
if(ApplyMap('WBS_Des_MAP',[Project Code],0)<>0,[Project Code],
'C1000'
))))
as WBS_Final_Code,
ApplyMap('AssignmentToWBSMap',Co.code,0) as WBS_Final_code,
H.Text as Header_Text
Resident OutFlowData;
Regards,
Keerthi KS
Are you saying that you want to use Join instead of Mapping/ApplyMap method to achieve the same result as your original code???
Yes to join both tables
Need to see your script for OutFlowData to give better direction.
OutFlowData:
V.Code,
V.Name,
[Doc. Type],
[Payment Doc No],
[Line Item No],
[Payment Date],
[Spl G/LAcc],
[Paid amt],
[TDS Amt],
[Paid Amt+TDS],
[Line Item Amt],
[Inv Doc No],
Year,
[Bill No],
[Inv Date],
[Source Doc.Type],
[Inv Posting Date],
[Inv Amt],
Curr.,
[PO No],
[PO Item No],
[PO Date],
[PO Value],
[Service Activity],
[Activity Short Text],
Mat.Code,
Mat.Desc,
[WBS Element],
Assignment,
[Network Activity],
[Internal Order],
[Project Code],
[Project Name],
[Payment Method],
[Payment Ref.No],
[Cheque Date],
H.Text,
[G/L Acc.],
[G/L Desc.],
[Payee Bank],
[Name of Bank],
Cl.Doc.No,
Cl.Date
