Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
koushikvutha
Partner
Partner

Rename Fields Mapping

Hey devs


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.

Regards

K



1 Solution

Accepted Solutions
koushikvutha
Partner
Partner
Author

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.

Regards

K

View solution in original post

2 Replies
koushikvutha
Partner
Partner
Author

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.

Regards

K

View solution in original post

swuehl
MVP
MVP

You can't rename to a key field using RENAME FIELD.

Try using ALIAS statement before loading your tables.