Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey i am trying to create a pivot table as given in the excel being attached
And also i have create a data mapping for material description
if( Match([MM Material Grp Desc],'Condensing Units','Evaporating Units'),'REF UNITS',if([MM Material Grp Desc]='Mortury','Mortury','Insulation'))as Description,
if( [A/c assign.]=2,'MFG Products',if( [A/c assign.]=1,'Traded Product',if([Sales Order Type]='ZINS','Installation',if( WildMatch([WBS Element],'DEF*'),'Others'))))as TYPE,
So the wildmatch doesnt function in this case as i want to.
Like i will be able to Show Others under the Profit Center table if the Wildmatch function works.
Let me know.Thanks.Really Urgent!!
Deepak the excel only didn't help... could you paste the scrip of loading the data?
Booking:
LOAD [Sales Office]as [Booking_Sales Office],
[Sales Order Type],
[Sales Order],
[SO Item Date],
[Sold to Party Code],
[Sold to Party Name],
[Material NO],
[Order Quantity],
[Total Sales Value],
VAT as Booking_VAT,
CST as Booking_CST,
[Total Inv. Value],
Plant,
[Distr Channel],
UOM,
Currency,
[Sales Amount],
[Material Cost],
[Purchase Cost],
[Gross Margin %],
[Total Cost],
[Net GM %],
[Net GM],
[Gross Margin],
[Sales Employee Code],
[Sales Employee Name],
[Foreign Currency],
[Original Material Gr],
[Original Material Gr1],
[A/c assign.],
[Add Vat],
[Additional Discount],
[Addl Sales Commssion],
[Cash Discount],
[Customer Group],
[Delivery Charges],
[Divi Desc],
[Education Tax],
[Extended Warranty Ex],
[Freight Charges],
[Handling Charge],
[Higher Education Tax],
INDUSTRY,
[Installation Charges],
Insurance,
[Insurance Charges],
[Material Group 1],
[Material Group 2],
[Material Group 3],
[Material NO Desc],
[MG 1 Desc.],
[MG 2 Desc.],
[MG 3 Desc.],
[MM Material Grp Desc],
if( Match([MM Material Grp Desc],'Condensing Units','Evaporating Units'),'REF UNITS',if([MM Material Grp Desc]='Mortury','Mortury','Insulation'))as Description,
if( [A/c assign.]=2,'MFG Products',if( [A/c assign.]=1,'Traded Product',if([Sales Order Type]='ZINS','Installation',if( WildMatch([WBS Element],'DEF*'),'Others'))))as TYPE,
[MM Matrial Grp],
Octroi,
[Octroi Charges],
[Other Expenses],
[Packing Charges],
[Plant Desc],
[Pos No],
[Primary Freight],
[Qty/Tonnage Disc],
[Reason for Rejection],
Region,
Retailer,
[Retailer desc],
[Sales Commssion],
[Sales Dealer],
[Sales Dealer Name],
[Sales District],
[Sales Office Desc],
[Sales Order Desc],
[Secondary Freight],
Segment,
[Service Dealer],
[Service Dealer Name],
[Service Tax] as [Booking_Service Tax],
[Ship to Party],
[Ship to Party Name],
[Social Security Cess],
[Sold to Party PO Date],
[Sold to Party PO Number],
Tonnage,
TOP,
Usage,
[User ID],
[User name],
[Valuation Field],
[WBS Element],
[Work Order Date],
[Work Order No],
[Value in Foreign Cur],
Division as Booking_Division
FROM
(ooxml, embedded labels, table is Sheet1);
This is the script used for loading the data.Would require a quick turnaround.
So i think you attached a wrong excel....
Bu looking for your Nest if, it could be something misplaced. the wildmatch is in a else of sales = ZINS, that is in a else of A/c assing = 1 , that is on a else of A/C Assign = 2 ... And the wildmatch if false will bring null... it is that order ?
if( [A/c assign.]=2,
'MFG Products',
if( [A/c assign.]=1,
'Traded Product',
if([Sales Order Type]='ZINS',
'Installation',
if( WildMatch([WBS Element],'DEF*'),
'Others',
null()
)
)
)
)
as TYPE,