new to qlikviewMatch data

[qlikapple]

Hi all , I am

[qlikapple]

Hi all , i am new to qlik

i have data below , My requirement is attched, anyon eplease help

[Siva_Sankar]

Hi Sahaja,

Can you explain breifly about your question?

Qlik Community Tip: How to Get Answers to Your Post

-siva

[Siva_Sankar]

Hi Sahaja,

Find the attached output as you expected,

[Table A]:

Load*,

if(len(GRPMain)=0,'',

if(GRP=GRPMain,'Y','N') ) as GRPMATCH;

Load * inline

[

Incidents,GRP,GRPMain

1,A,A

2,B,C

3,C,B

4,D

5,E

6,F

7,G

];

-Regards

Siva

[qlikapple]

HI all , can anyone plese help

I didnt get the O/p as expected

i  have data like this from direct database, but the user gave one excel sheet i nee to map with excel sheet and see if its matches i have to keep as Y else N

Suppose

TAbleA

Ticket  AssignemntGRP

1   GRPA

2 GRPB

3 GRPC

4 GRPD

Table B(user gave Excel sheet)

GRP

GRPC

GRPD

GRPA

GRPE

I want the O/P as

Ticket   AssignmentGRP   Matches

1            GRPA               Y

2             GRPB            N

3             GRPC           Y

4           GRPD           Y

Anyone please help , as the data is huge in database, i want to change in the sript

[Anil_Babu_Samineni]

How about this?

If(ApplyMap('TAbleA', AssignemntGRP, Null()) as AssignemntGRP

Then You have to write like below

If(GRP = AssignemntGRP, 'Y', 'N') as Flag

[sasikanth]

HI

Try below one

Table B  (From user)

LOAD * INLINE [

AssignemntGRP

GRP

GRPC

GRPD

GRPA

GRPE

];

TAbleA:

Load Ticket,AssignemntGRP, if Exists(AssignemntGRP),'Y','N') as Matches;

LOAD * INLINE [

Ticket  AssignemntGRP

1   GRPA

2 GRPB

3 GRPC

4 GRPD

];