Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Market field,
In that market field i have Asean Pac, Benelux etc, Now i need to get instead of Asean Pac it should be changed to ANZ, SEA, Korea,Indonesia..
Can you help me how to do it.
Thanks,
Bharat
replace with this
pick(MATCH(Region,'ANZ','SEA','Korea','Indonesia')+1,Market,'Austrailia and Newzeland','South east asia','Korea','Indonesia')as Market,
Hi Kishore,
Your question is not very clear. Do you want to harmonize the data using mapping load or do you want to convert rows into columns like generic load scenerio.
Regards,
Neha
Front end or Back End?
Hi Neha,
PFA app, i have a market list box there i have Asean Pac as one of the market, so instead of Asean Pac it should be changed to Australia New Zealand , Korea, Indonesia , South East Asia.
Please let me know if you need anything more
Thanks,
Bharat
Hi Anil,
It should be in back end.
Attached app for reference;
Thanks,
Bharat
Try using: ApplyMap ‒ QlikView
Let us know what are the value you need to map. If any mapping table is there than it would be a plus. Apply map is the way to go here.
Hi Pradosh,
It is Market..
Thanks,
Bharat
Hi Tresesco,
I need to get all the markets and instead of Asean Pac it should be changed to 4 other markets.
Can i use apply map here.
And please let me know how it combine these with the existing market field.
Thanks,
Bharat
Hi Tresesco,
PFA app for more reference.
Thanks,
Bharat