Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Apply map coming in as zero

I have 8 tables and 4 of them need fields from other tables, sometimes 1 table pulls fields from 2 different tables.

I set up mapping tables at the end of my script:

[ML_table 3 field 1]:

Mapping Load

[primarykey],

SUM([field) as [field1]

Resident [table that the field is coming from]

Group by [pirimarykey];

on the table that I need to pull this field, I put applymaps at the end of my load script:

  Applymap ('ML_table 3 field 1',[primarykey],'N/A') as [mappingloadfield],

in a preceding load to that table, I use those fields in calculations.

I am getting '0's' in all of the columns. I have multiple applymaps in my loads and multiple mapping tables.

Could someone assist?

Thanks!!

2 Replies
sunny_talwar

I don't see a reason for a fail here. Can you share the complete script?

swuehl
MVP
MVP

I think there are some small typos in your code, but I assume they are just copy and paste errors.

I set up mapping tables at the end of my script:

[ML_table 3 field 1]:

Mapping Load

[primarykey],

SUM([field) as [field1]

Resident [table that the field is coming from]

Group by [pirimarykey];

on the table that I need to pull this field, I put applymaps at the end of my load script:

  Applymap ('ML_table 3 field 1',[primarykey],'N/A') as [mappingloadfield],

in a preceding load to that table, I use those fields in calculations.

I am getting '0's' in all of the columns. I have multiple applymaps in my loads and multiple mapping tables.

You stated: "I set up mapping tables at the end of my script:"

Mapping tables need to be loaded before they are actually used (e.g. by using ApplyMap() ). Note there will be no script error if the mapping table does not exist.

Other than that, check the results of your mappings before doing the calculations.