Rename field and then applymap

[stjernvd]

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?

[sunny_talwar · Accepted solution]

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)...

[Anonymous]

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/

[Anonymous]

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

[sunny_talwar]

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.

[stjernvd]

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?

[sunny_talwar]

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

[Anonymous]

done

[sunny_talwar]

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.

[sunny_talwar]

Awesome