Load not Pulling Previous Fields

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

Hello,

My load statement is as follows:

NoConcatenate

GMR:

Load

[Posting Date] as CalendarDate,

ApplyMap('PC_Mapping', MappingKey, 'Not Mapped') as [Profit Center Desc.],

ApplyMap('CC_Mapping', MappingKey, 'Not Mapped') as [Cost Center Desc.],

ApplyMap('IS_Mapping', MappingKey, 'Not Mapped') as [I/S Mapping],

ApplyMap('FS_Mapping', MappingKey, 'Not Mapped') as [F/S Mapping],

ApplyMap('AT_Mapping', MappingKey, 'Not Mapped') as [Account Type],

ApplyMap('FST_Mapping', MappingKey, 'Not Mapped') as [F/S Tab],

ApplyMap('GMGL_Mapping', MappingKey, 'Not Mapped') as [GM G/L Category],

if([Billing Type]='ZRE',Quantity * -1,if([F/S Mapping]='Sales Discounts','0',Quantity)) as [Adjusted Qty]

//if([Billing Type]='ZRE',Quantity * -1,Quantity) as [Adjusted Qty]

Resident BSEG2

;

Drop Table BSEG2;

For some reason when this is run the second nested "if" does not recognize the field "[F/S Mapping]" and the load fails. I have used the commented portion before and it worked fine. The "[Billing Type]" is contained in the previous tables leading to this. Any thoughts on why this wouldn't work?

Thanks

Re: Load not Pulling Previous Fields

m_woolf — Tue, 08 May 2018 19:42:24 GMT

if([Billing Type]='ZRE',Quantity * -1,if(ApplyMap('FS_Mapping', MappingKey, 'Not Mapped')='Sales Discounts','0',Quantity)) as [Adjusted Qty]

topic Load not Pulling Previous Fields in QlikView

Load not Pulling Previous Fields

Re: Load not Pulling Previous Fields