Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
Thanks!
Found a way using the Lookup function.