topic Re: Mapping Load in QlikView

Mapping Load

Mon, 16 Jul 2012 14:39:19 GMT

Hi Can anyone see anything wrong with the SQL below. I keep getting the error message that the field "Dummy_Division" does not exist and I cannot see what I am doing wrong

DummyDivisionMap:
MAPPING LOAD
Product_Number,
Dummy_Division

RESIDENT Products_All_Codes;

Transactional:

LOAD
     //Act_or_Est,
     //Period,
     Despatch_RDC,
     date(Invoice_Date,'DD/MM/YYYY') as Invoice_Date,
     Invoice_Number,
     Customer_Number,
     Account_Number,
     Despatch_Note_Number,
     //Order_Number,
     Product_Number,
     Delivery_Type,
     Credit_Note_Code,
     Units,
     Volume,
     Lines,
     Sales_Value,
     Gross_Contribution,
     Customer_Retro,
     Post_Retro_Margin,
     Storage_Cost,
     Preparation_Cost,
     Transport_Cost,
     Logistical_Cost,
     Logistics_Sales_Recovery,
     Net_Logistical_Cost,
     Vendor_Retro,
     Operating_Profit,
     [EOS/NEOS],
     Table_ID,
     Price_Indicator,
     Std_Sales,
     BackOrder,
     //EU_Category,
     Delivery_Post_Code,
     Delivery_Outer_Post_Code,
     Delivery_Postal_Area_Code,
     Composite,
     Component_Units,
     End_Consumer,
     Promotion_Code,
     Promotion_Cost_Price,
     Selling_Day_Number,
     ApplyMap ('DummyDivisionMap',Dummy_Division,'MISSING') as Division,
     Invoice_Type
     //Data_LastUploaded,
     //Data_LastUploaded_By

FROM [$(zFileMask)] (qvd);

Re: Mapping Load

MayilVahanan — Mon, 16 Jul 2012 14:43:52 GMT

Hi,

Is there a field in Dummy_Division in [$(zFileMask)] (qvd);

Check once..Hope it helps

Re: Mapping Load

Mon, 16 Jul 2012 14:46:51 GMT

Yes field exists.

The table "DummyDivisionMap" Loads correctly I get the error when the second table loads

Re: Mapping Load

MayilVahanan — Mon, 16 Jul 2012 15:16:50 GMT

Hi,

Did u Check the fieldname Dummy_Division available in second table??

Re: Mapping Load

Mon, 16 Jul 2012 15:18:08 GMT

Yes all checked

Re: Mapping Load

MayilVahanan — Mon, 16 Jul 2012 15:26:00 GMT

Hi,

Can you post a sample file? That helps to find the mistake..If possible , send the xls file or qvd file too??

Re: Mapping Load

CELAMBARASAN — Mon, 16 Jul 2012 15:55:23 GMT

I think logic is wrong. check it?

You should use ApplyMap ('DummyDivisionMap',Product_Number,'MISSING') as Division,

Syntax

applymap('mapname', expr [ , defaultexpr ] )

As per your mapping load the expr maps the product number field and the gets the corresponding Dummy_Division field value.

I think Dummy_Division is not a Field in the Transactional table

Re: Mapping Load

Tue, 17 Jul 2012 06:52:09 GMT

You are correct Dummy_Division is not in the Transaction table, but that is what I am trying to do

many thanks

Re: Mapping Load

CELAMBARASAN — Tue, 17 Jul 2012 15:02:35 GMT

Hi,

Did you chk with this

ApplyMap ('DummyDivisionMap',Product_Number,'MISSING') as Division