topic Re: mapping fields in QlikView

mapping fields

Thu, 21 Apr 2016 12:03:14 GMT

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?

Re: mapping fields

sunny_talwar — Thu, 21 Apr 2016 15:26:21 GMT

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;

Re: mapping fields

Thu, 21 Apr 2016 15:47:14 GMT

Thanks!

Found a way using the Lookup function.