Discussion Board for collaboration related to QlikView App Development.
I am looping two individual tables whose field names are defined by uniqueIds (Fact1 and Fact2 Sheet) and mapping it to a table (System sheet).
Problem here is that fieldId 103,104 in Fact1 has the same mapping field name to fieldid 107,108 in Fact2.
Fact1 table loops and the correct fieldnames are mapped whereas 107,108 id in Fact2 doesnt map.
Please see attached data.
Answer self found.
First Looped table needs to be dropped after mapping so that the next iteration of loop is a fresh loop.
Rename function doesnt have a criteria to specify the table that needs renaming.. it just finds the first instance values in the mapping table.
View solution in original post
You can't rename to a key field using RENAME FIELD.
Try using ALIAS statement before loading your tables.