topic Mapping load Issue in QlikView

Mapping load Issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi ,

i am new in qlikview , i am trying to mapping load in my code but i am getting error in my code .i want to map
[GSTRP] as Date column into FACT_MaintenanceOrderHeader .

below is my code;

Dim_OrderHdr:

Load

[AUFNR] as [Order_AUFNR],

[GLTRP] as [Basic fin. date_GLTRP],

[GSTRP] as [Bas. start date_GSTRP],

[GSTRP] as Date,

;

SQL Select AUFNR GLTRP GSTRP from AFKO where GSTRP >= '20120401'

;

//WHERE AUFNR IN (SELECT AUFNR from AFKO WHERE GLTRP Between '20100401' AND '20110430')

STORE * FROM [Dim_OrderHdr] INTO E:\ test\Dim_OrderHdr.QVD;

DROP TABLE [Dim_OrderHdr];

Dim_OrderHdrtest:

Mapping Load

Order_AUFNR,

Date,

from

E:\ test\Dim_OrderHdr.QVD;

FACT_MaintenanceOrderHeader:

NoConcatenate

Load

[AUFNR] as [Order_AUFNR],

[QMNUM] as [Notification_QMNUM];

SQL Select AUFNR QMNUM from AFIH

;

STORE * FROM [FACT_MaintenanceOrderHeader] INTO E:\ test\FACT_MaintenanceOrderHeaderbase.QVD;

FACT_MaintenanceOrderHeader:

NoConcatenate

Load

[Order_AUFNR],

[Notification_QMNUM],

ApplyMap('Dim_OrderHrdtest','O_AUFNR','unknown');

from

E:\ test\Dim_OrderHdr.QVD;

please do the needful:

Re: Mapping load Issue

Anonymous — Mon, 09 Oct 2017 14:42:33 GMT

can you post error message?

whatI notice you Need to pass a correct value to applymap and passfieldname without quotes

FACT_MaintenanceOrderHeader:

NoConcatenate

Load

[Order_AUFNR],

[Notification_QMNUM],

ApplyMap('Dim_OrderHrdtest',Order_AUFNR,'unknown') as MyDate;

from

E:\ test\Dim_OrderHdr.QVD;

Re: Mapping load Issue

atoz1158 — Mon, 09 Oct 2017 14:42:43 GMT

You seem to have a comma after the date field in your mapping load this needs to be removed

Regards

Adrian

Re: Mapping load Issue

prieper — Mon, 09 Oct 2017 14:46:54 GMT

Dim_OrderHdrtest:

Mapping Load

Order_AUFNR,

Date

from

E:\ test\Dim_OrderHdr.QVD;

has one Comma too much

APPLYMAP has the fieldname without apostrophs, think that you refer to the field Order_AUFNR?:

FACT_MaintenanceOrderHeader:

NoConcatenate

Load

[Order_AUFNR],

[Notification_QMNUM],

ApplyMap('Dim_OrderHrdtest',O_Order_AUFNR,'unknown');

from

E:\ test\Dim_OrderHdr.QVD;

Re: Mapping load Issue

hari8088 — Mon, 09 Oct 2017 14:54:11 GMT

Hi in applymap map syntax we should not use single quates('') for field name and this filed must exits in current table.

see below

Dim_OrderHdr:

Load

[AUFNR] as [Order_AUFNR],

[GLTRP] as [Basic fin. date_GLTRP],

[GSTRP] as [Bas. start date_GSTRP],

[GSTRP] as Date,

;

SQL Select AUFNR GLTRP GSTRP from AFKO where GSTRP >= '20120401'

;

//WHERE AUFNR IN (SELECT AUFNR from AFKO WHERE GLTRP Between '20100401' AND '20110430')

STORE * FROM [Dim_OrderHdr] INTO E:\ test\Dim_OrderHdr.QVD;

DROP TABLE [Dim_OrderHdr];

Dim_OrderHdrtest:

Mapping Load

Order_AUFNR,

Date,

from

E:\ test\Dim_OrderHdr.QVD;

FACT_MaintenanceOrderHeader:

NoConcatenate

Load

[AUFNR] as [Order_AUFNR],

[QMNUM] as [Notification_QMNUM];

SQL Select AUFNR QMNUM from AFIH

;

STORE * FROM [FACT_MaintenanceOrderHeader] INTO E:\ test\FACT_MaintenanceOrderHeaderbase.QVD;

FACT_MaintenanceOrderHeader:

NoConcatenate

Load

[Order_AUFNR],

[Notification_QMNUM],

ApplyMap('Dim_OrderHrdtest',Order_AUFNR,'unknown');

from

E:\ test\Dim_OrderHdr.QVD;