topic Rename Fields Mapping in QlikView

Rename Fields Mapping

koushikvutha — Thu, 14 Apr 2016 09:47:43 GMT

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

koushikvutha — Thu, 14 Apr 2016 10:52:19 GMT

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

swuehl — Thu, 14 Apr 2016 11:06:14 GMT

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

Try using ALIAS statement before loading your tables.