topic Re: Rename field and then applymap in QlikView

Rename field and then applymap

stjernvd — Tue, 15 Dec 2015 12:16:18 GMT

Hi,

I am trying to load and rename a field:

CA:

Load

Name,

ID,

Place as Flow

from (file)...

CA_1:

Load

Name,

ID,

Applymap ('Flow Map', Flow, Flow)

Resident CA;

in my mapping table 'Flow Map', the field is called 'Flow' which is why I renamed it above.

But it won't work. Why?

Re: Rename field and then applymap

sunny_talwar — Tue, 15 Dec 2015 12:20:43 GMT

Not sure what you are trying to do but the second argument in ApplyMap() function is the field name from the table you are mapping into:

CA:

Load

Name,

ID,

Place

ApplyMap('Flow Map', Place) as Flow

from (file)...

Re: Rename field and then applymap

Anonymous — Tue, 15 Dec 2015 12:21:42 GMT

Applymap() is used when you want to map only one column.

If you want to map Flow only then comment Name field..

try like this:

CA:

Load

//Name,

ID,

Place as Flow

from (file)...

CA_1:

Load

Name,

ID,

Applymap ('CA', ID, Flow) as Flow

Resident CA;

check this as well:

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Re: Rename field and then applymap

Anonymous — Tue, 15 Dec 2015 12:23:45 GMT

Sunny, instead of 'Flow Map' their shud be mapping table name which is CA.

Re: Rename field and then applymap

sunny_talwar — Tue, 15 Dec 2015 12:24:36 GMT

Balraj bro, no offense but more than helping, it seems to be confusing to what exactly you are proposing. Please try to make changes to your single post so that the user can understand what are you trying to help. You have three similar posts and I am not even sure which one is doing what.

Re: Rename field and then applymap

stjernvd — Tue, 15 Dec 2015 12:24:59 GMT

Hi Sunny,

My mapping table looks like this:

Flow FlowDest

So I want to apply map to 'Place' but I can't do that until I rename it Flow.

CA:

Load

Name,

ID,

Place as Flow

from (file)...

CA_1:

Load

Name,

ID,

Applymap ('Flow Map', Flow, Flow)

Resident CA;

So why isn't my method working?

Re: Rename field and then applymap

sunny_talwar — Tue, 15 Dec 2015 12:25:33 GMT

Ya my guess is that Flow Map is table which isn't share with us on this post. But stjernvd‌ can disagree with me and we can make changes

Re: Rename field and then applymap

Anonymous — Tue, 15 Dec 2015 12:27:10 GMT

done

Re: Rename field and then applymap

sunny_talwar — Tue, 15 Dec 2015 12:28:53 GMT

You can, it is different story if you don't want to. Because QlikView doesn't care if the table you are mapping from has the same field name or not. What matters is the content within the fieldname needs to match exactly.

Re: Rename field and then applymap

sunny_talwar — Tue, 15 Dec 2015 12:29:03 GMT

Awesome