Link Tables

firoz24 — Mon, 11 Dec 2023 05:10:12 GMT

Hi Guys,

CrossTable(Week1,Value,9)
[Capex Plan]:
LOAD
"Project List",
Domain,
"Budget From A7x",
"Current Demand",
"PO Released",
"E-decision & PO under Progress",
"RCT Approval",
'Plan' as Type1,

"Cash Out until Oct 23",
W01,
W02,
W03,
W04,
W05,
W06,
W07,
W08,
W09,
W10,
W11,
W12,
W13
FROM [lib://source Path (techadmin)/ISIT/BUDGET/Capex Splitup 2.xlsx]
(ooxml, embedded labels, header is 1 lines, table is [Capex Plan]);

CrossTable(Week1,Value,9)
[Capex Actual]:
LOAD
"Project List",
Domain,
"Budget From A7x",
"Current Demand",
"PO Released",
'Actual' as Type1,
"E-decision & PO under Progress",
"RCT Approval",
"Cash Out until Oct 23",
W01,
W02,
W03,
W04,
W05,
W06,
W07,
W08,
W09,
W10,
W11,
W12,
W13
FROM [lib://source Path (techadmin)/ISIT/BUDGET/Capex Splitup 2.xlsx]
(ooxml, embedded labels, header is 1 lines, table is [Capex Actual]);

How to work on this data I want to compare Plan vs actual by two excel sheets all fields are common I need to link this two table by type which is 'Plan' as Type & 'Actual' as Type'

Please guide me in this process I dont know how to proceed this

Reply ASAP

Thank you

topic Link Tables in Featured Members

Link Tables