Map to Fields

[Nagaraju_KCS]

Hi Community,

I haev 2 tables

Table1:  (Like Master Table) Here i have duplicate ID, but service different.

ID	Service
10010	ABC
10011	BCA
10001	CBA (Test)
10001	CBA (Case)

Table2:

ID	Category	Cost
10010	Samsung	1000
10011	Nokia	2000
10001	Test	3000
10001	Case	4000

I have created one calculated Dimension field...............

LOAD *, If(Service='ABC', 'Button1',

  If(Service='BCA', 'Button2',

  If(wildmatch(Service,'*Test*'), 'Button3',

  If(wildmatch(Service,'*Case*'), 'Button4')))) as Button;

If i am click Button 3 , in table 2 i have to map Test record only

10001

Test

3000

If i am click Button 4 , in table 2 i have to map Case record only

10001

Case

4000

How to map these particular records..

PFA,

[sunny_talwar · Accepted solution]

May be try this:

LOAD ID,

  If(Service='ABC', 'Button1',

  If(Service='BCA', 'Button2',

  If(wildmatch(Service,'*Case*'), 'Button3',

  If(wildmatch(Service,'*Test*'), 'Button4')))) as Button,

  AutoNumber(ID&Pick(WildMatch(Service, '*Test*', '*Case*') + 1, 'NA', 'Test', 'Case')) as Key;

LOAD ID,

    Service

FROM

[https://community.qlik.com/thread/208840]

(html, codepage is 1252, embedded labels, table is @1);

LOAD AutoNumber(ID&Pick(WildMatch(Category, '*Test*', '*Case*') + 1, 'NA', 'Test', 'Case')) as Key,

    Category,

    Cost

FROM

[https://community.qlik.com/thread/208840]

(html, codepage is 1252, embedded labels, table is @2);

[Nagaraju_KCS]

Thank You Sunny....