mapping fields

[#1]

I have two fields A.initiatedCity and B.initiatedCity, loaded in different load statements, which for other purposes needs to be separated. I would like both to be mapped to a third field CityName, loaded in a separate statement to allow them to be linked to a fourth namely RegionName.

What is the best solution?

[sunny_talwar]

Probably use a LinkTable to create the new Field

Link:

LOAD A.initiatedCity as CityName,

          UniqueKeyFromThisTable,

          'A' as Flag

Resident A;

Concatenate (Link)

LOAD B.initiatedCity as CityName,

          UniqueKeyFromThisTable,

          'B' as Flag

Resident B;

[#3]

Thanks!

Found a way using the Lookup function.