4 Replies Latest reply: Dec 12, 2014 7:31 AM by Arthur Molino RSS

    Wildmatch function not executing!!!

    Abhishek Hariharan

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

        • Re: Wildmatch function not executing!!!
          Arthur Molino

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

          • Re: Wildmatch function not executing!!!
            Abhishek Hariharan

            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

            [E:\Abhishek Hariharan\export.Z08.xlsx]

            (ooxml, embedded labels, table is Sheet1);

              • Re: Wildmatch function not executing!!!
                Abhishek Hariharan

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

                  • Re: Wildmatch function not executing!!!
                    Arthur Molino

                    So i think you attached a wrong excel.... 

                    Screen Shot 2014-12-12 at 10.22.41.png

                     

                    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,