Wildmatch function not executing!!!

[abhishek_bigdat]

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!!

[arthur_dom]

  Deepak the excel only didn't help... could you paste the scrip of loading the data?

[abhishek_bigdat]

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);

[abhishek_bigdat]

This is the script used for loading the data.Would require a quick turnaround.

[arthur_dom]

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,