Conditional logic not working in mapping

Mon, 22 Aug 2016 11:07:26 GMT

I have a main table with an associated lookup via a left join. QV file and dataset attached ( Please note this is just a subset of data, my actual dataset is a lot larger however the fields are exactly what you see).

I am joining on SALES_ID with the resultant table displayed. Quite simply what I wish to do is for all the SALES_ID values that are in the main table but not in the lookup ( these all begin 99 ), then put the SALES_TYPE_NEW into a separate bucket called 'TAXABLE'. Current output and expected output displayed below.

Current Output :

SALES_ID	SALES_TYPE_NEW	LOCATION_CODE	REGION
1000	PARTEX	1	FRANCE
2000	CASH	2	UK
3000	PAYPAL	3	BRAZIL
4000	COUNTER	4	PORTUGAL
5000	ONLINE	5	IRELAND
9900		11	ITALY
9901		10	SCOTLAND

Expected Output :

SALES_ID	SALES_TYPE_NEW	LOCATION_CODE	REGION
1000	PARTEX	1	FRANCE
2000	CASH	2	UK
3000	PAYPAL	3	BRAZIL
4000	COUNTER	4	PORTUGAL
5000	ONLINE	5	IRELAND
9900	TAXABLE	11	ITALY
9901	TAXABLE	10	SCOTLAND

topic Conditional logic not working in mapping in QlikView

Conditional logic not working in mapping