Rename Fields Mapping

[koushikvutha]

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

[koushikvutha · Accepted solution]

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

[swuehl]

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

Try using ALIAS statement before loading your tables.