Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
I don't see a reason for a fail here. Can you share the complete script?
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.