Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Change Column Names

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

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

replace with this

pick(MATCH(Region,'ANZ','SEA','Korea','Indonesia')+1,Market,'Austrailia and Newzeland','South east asia','Korea','Indonesia')as Market,

Learning never stops.

View solution in original post

28 Replies
neha_sri
Creator III
Creator III

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

Anil_Babu_Samineni

Front end or Back End?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bharatkishore
Creator III
Creator III
Author

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

bharatkishore
Creator III
Creator III
Author

Hi Anil,

It should be in back end.

Attached app for reference;

Thanks,

Bharat

tresesco
MVP
MVP

pradosh_thakur
Master II
Master II

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.

Learning never stops.
bharatkishore
Creator III
Creator III
Author

Hi Pradosh,

It is Market..

Thanks,

Bharat

bharatkishore
Creator III
Creator III
Author

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

bharatkishore
Creator III
Creator III
Author

Hi Tresesco,

PFA app for more reference.

Thanks,

Bharat