Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

mapping fields


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?

2 Replies

Re: mapping fields

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;

Not applicable

Re: mapping fields

Thanks!

Found a way using the Lookup function.

Community Browser