Change Column Names

[bharatkishore]

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

[pradosh_thakur]

Hi

thats what i told if you about using if condition in Region

LOAD Cluster,

     Country,

     Denominator,

     Entitlement,

     GSS,

     KPIScope,

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

     Metric,

     MG,

     Modality,

     Numerator,

     Period,

     Region

FROM

Target.qvd

(qvd);

[bharatkishore]

Sorry but when i use this condition in Market is Asean Pac is there. But Korea  and Indonesia are missing. Attached image for reference:

[pradosh_thakur · Accepted solution]

replace with this

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

[bharatkishore]

Thanks a lot Pradosh. Thank you so much.

Can you please help me what does Pick and +1 do.

Please don't mind.

[neha_sri]

hi Bharat,

Even if you somehow get the Region field in market, but how will you split the data in that case,

you should have a proper logic to distribute the fact data over the new Markets.

Regards,

Neha

[pradosh_thakur]

No problem my friend.

match will return 0 if no match 1 if anz 2 if sea and so on. so plus 1 will change no match to 1, anz to 2 and so on .

pick will pick accordingly.

http://help.qlik.com/en-

US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/pick.htm

match - script and chart function ‒ QlikView

[bharatkishore]

Thanks a lot.....

[Anonymous]

Very useful information.

Thanks.

[Anonymous]

Very useful information. Thanks.