topic Apply Map Not Working in QlikView

Apply Map Not Working

Anonymous — Mon, 09 Mar 2015 19:17:35 GMT

I basically have a job title that I want to add as a field into several tables. Syntax is:

Map_JobTitle:

[Full Name],

[Job Title]

From etc ...

ApplyMap('JobTitle', [Preparer Name]) as [Job Title]

What am I doing wrong?

Re: Apply Map Not Working

Anonymous — Mon, 09 Mar 2015 19:25:32 GMT

Map_JobTitle:

Mapping LOAD

[Full Name],

[Job Title]

From etc ...

ApplyMap('Map_JobTitle', [Preparer Name]) as [Job Title]

Re: Apply Map Not Working

Mon, 09 Mar 2015 19:26:23 GMT

First parameter is the table name so it should be

ApplyMap('Map_JobTitle', [Preparer Name]) as [Job Title]

Re: Apply Map Not Working

manojkvrajan — Mon, 09 Mar 2015 19:26:31 GMT

David - Please give the Mapping Table Name as the Parameter1 and it should work...

ApplyMap('Map_JobTitle', [Preparer Name]) as [Job Title]

Re: Apply Map Not Working

Anonymous — Mon, 09 Mar 2015 19:32:40 GMT

Rookie mistakes. Thank you all very much.

Re: Apply Map Not Working

Anonymous — Mon, 09 Mar 2015 19:42:17 GMT

Having another issue. The apply map is returning no results when I apply it to several different tables ... Any ideas?

Re: Apply Map Not Working

Anonymous — Mon, 09 Mar 2015 20:20:02 GMT

synthetic keys?

- if you are re-applying the map, giving it the same names, and if the the table already has a link then i would assume it's the synthetic key/Loop?.

else the values in Prepare Name and the Full Name do not match. or does not exist.

Question:

must you apply the map to several tables? are they linked together any anyways?

Re: Apply Map Not Working

Anonymous — Mon, 09 Mar 2015 21:20:10 GMT

it several different tabs on the same spreadsheet. I pretty much just want to put the employees Job Title in the same table that their data exists. I can work around this by linking tables via an "AS" clause but I thought ApplyMap would be more effective.

Re: Apply Map Not Working

Anonymous — Mon, 09 Mar 2015 21:47:37 GMT

Hey David.

could you please press Ctrl + T in your QV application, to look at the "table viewer" if there are dashed lines all over it means that there are loops within your application, or any synthetic keys

this may be cause by adding the job title to all the tables that their data exists.

meaning your tables already had existing links, and you're adding identical fields into other tables. QV then looks at those identical fields and links them, therefore creating a loop or synthetic keys.

to solve this i suggest you

1) rename all your fields if you want to keep it that way, however it will mean you will have more than 1 job title field. and may be confusing, and not a good practice

2) map the job title to only one table, and have linked automatically via the links already created in your QV apps.

- data in QV should flow through if linked correctly