Need help converting Excel logic into Qliksense

[Gautam98]

HI All,

I need to convert the below excel formula into qliksense.

=IF(LEFT(D12,2)="ST",IF(IFERROR(VLOOKUP(B12,'SKU-LocMaster'!B:AI,34,0),"Steel Non BPR")="BPR","Steel","Steel Non BPR"),IF(IFERROR(VLOOKUP(B12,'FG Master'!A:D,4,0),"Non FG")="FG","FG",IFERROR(VLOOKUP(B12,'SKU-LocMaster'!B:AK,34,0),IF(LEFT(D12,2)=T$1,"CP Non BPR",IF(LEFT(D12,2)=T$2,"CP Non BPR",IF(LEFT(D12,2)=T$3,"CP Non BPR",IF(LEFT(D12,2)=T$4,"CP Non BPR","Consumables")))))))

where D12= Material

B12=Loc Code

Please let me know if additional details are required.

Thanks,

Gautam

[vinieme12]

create mapping tables for these rows

SKU-LocMaster'!B:AI,34,0

MappingTable1:

Load column1,column34 fromSKU-LocMaster

FG Master'!A:D,4,0)

MappingTable2:

Load column1,column4 from  FG Master

then use below in load script

IF(LEFT(Material,2)='ST'
,IF(wildmatch(Applymap('MappingTable1',[Loc Code],'Steel Non BPR'),'BPR')
,'Steel','Steel Non BPR')
,IF(wildmatch(Applymap('MappingTable2',[Loc Code],'Non FG'),'FG'),'FG'
,Applymap('MappingTable1',[Loc Code]
,IF(wildmatch(LEFT(Material,2),'T$1_value','T$2_value','T$3_value','T$4_value' )+1,'Consumables','CP Non BPR'))
) )  as NewField