how to copy field

[#1]

Hi,

i have this table

company , activity

c1,a1

c1,a2

c1,a3

c2,a1

c2,a2

c3,a3

i want to load this table 2 times in order to make comparison

i.e i want to load company as company1 and company as company2

but when i make that when i select from company1 it highlight the same selection in company2

how to solve this problem?

Thanks,

Mona

[renjithpl]

Try somthing like this,

hope this helps!!

Company:LOAD Company,
     Activity,
     Activity as Activity2FROM
[qlikview examples try\Book1.xlsx]
(ooxml, embedded labels, table is Sheet2);

Map1:Mapping Load
Company, Activity
Resident Company;

Newcompany:load
*, ApplyMap ('Map1', Company) as Company2
Resident Company;drop table Company;

regards

Renjith

[#3 · Accepted solution]

Thanks renjithpl

i have solved it by creating 2 tables resident the one i have