topic Re: Change Column Names in QlikView

Change Column Names

bharatkishore — Tue, 02 Jan 2018 08:53:34 GMT

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

Re: Change Column Names

neha_sri — Tue, 02 Jan 2018 09:20:41 GMT

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

Re: Change Column Names

Anil_Babu_Samineni — Tue, 02 Jan 2018 09:23:33 GMT

Front end or Back End?

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 09:29:58 GMT

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

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 09:31:00 GMT

Hi Anil,

It should be in back end.

Attached app for reference;

Thanks,

Bharat

Re: Change Column Names

tresB — Tue, 02 Jan 2018 09:33:04 GMT

Try using: ApplyMap ‒ QlikView

Re: Change Column Names

pradosh_thakur — Tue, 02 Jan 2018 09:37:35 GMT

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.

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 09:39:43 GMT

Hi Pradosh,

It is Market..

Thanks,

Bharat

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 09:45:24 GMT

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

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 09:48:04 GMT

Hi Tresesco,

PFA app for more reference.

Thanks,

Bharat

Re: Change Column Names

pradosh_thakur — Tue, 02 Jan 2018 09:48:18 GMT

Hi Bharat.

What i meant is From market if it is a then to a1,b then to b1 like this the complete set. Or else we will have some filed value whose mapping equivalent we dont know. If you can provide that in a excel we can use it in apply map.

Re: Change Column Names

tresB — Tue, 02 Jan 2018 09:50:31 GMT

Single value can't be broken down into multiple without proper logic. Try to share a sample data set with expected output.

Re: Change Column Names

tresB — Tue, 02 Jan 2018 10:12:16 GMT

With a more realistic sample data set, the proposition could have been better. With this sample, you could probably try like:

Load

If( Market='Asia Pac', Region, Market) as Market

In case, this is not what you need, please try to explain with more data columns.

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 10:13:44 GMT

Hi Tresesco,

I have a Market and Region and there in region i have ANZ, Indonesia,Korea ,SEA and Blank.

Now in Maket i have Africa, Asean Pac,Benelux,CEE, Dach etc.

Now when in Market instead of Asean Pac it should be changed to ANZ, Indonesia, Korea , SEA and rest of the markets should be there.

PFA app and please let me know if you need anything more.

Thanks,

Bharat

Re: Change Column Names

pradosh_thakur — Tue, 02 Jan 2018 10:18:53 GMT

LOAD Cluster,

Country,

Denominator,

Entitlement,

GSS,

KPIScope,

Market,

Metric,

MG,

Modality,

Numerator,

Period,

if(len(trim(Region))>0,Region,Market) as Region

FROM

Target.qvd

(qvd);

Re: Change Column Names

surendraj — Tue, 02 Jan 2018 10:21:37 GMT

If( Market='Asia Pac', 'ANZ | Indonesia | Korea | SEA ', Market) as Market

After that you can devide the string 'ANZ | Indonesia | Korea | SEA ' by make use of sub field function in preceding load.

subfield(Market,'|') as Market

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 10:24:07 GMT

Hi Tresesco,

Thanks a lot..

Only problem i have is Now in Market i have ANZ and SEA can you please help me how to re-name it to Australia and NewZealand for ANZ and South East Asia for SEA.

Thanks,

Bharat

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 10:25:13 GMT

Hi Pradosh,

Thanks a lot..

Can you please help me how to re-name it to Australia and NewZealand for ANZ and South East Asia for SEA for Market field

Thanks,

Bharat

Re: Change Column Names

pradosh_thakur — Tue, 02 Jan 2018 10:34:19 GMT

this may be

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,

if(len(trim(Region))>0,Region,Market) as Region

FROM

Target.qvd

(qvd);

use The If in Region if want to replace The blank else not,.

Re: Change Column Names

bharatkishore — Tue, 02 Jan 2018 10:42:30 GMT

Hi Pradosh,

This is working fine, but the region has been changed to Market fields.

Region fields should not be changed.

Please let me know how to do it.

Thanks,

Bharat