IF (Exists) statement

Anonymous — Wed, 16 Dec 2015 19:39:17 GMT

Hi:

I have two tables: Table A has project ID and Submitted Item ID. Table B has project ID and Selected Item ID which is a subset of Submitted Item ID. I need to add a "Selected?" column to Table A which indicates if an item is selected from each project ID. I was thinking using "If (exists ([Submitted Item ID],[Selected Item ID],'Y','N')" statement, but it ignores the project ID. Any better solution?

Thanks

Yvonne

Table A:

Project ID	Submitted Item ID	Selected?
123	Apple	Y
123	Banana	Y
123	Orange	N
123	Pear	N
456	Banana	N
456	Orange	N
456	Pear	Y
456	Watermelon	Y

Table B:

Project ID	Selected Item ID
123	Apple
123	Banana
456	Pear
456	Watermelon

Re: IF (Exists) statement

swuehl — Wed, 16 Dec 2015 19:48:25 GMT

LOAD

[Project ID] & [Selected Item ID] as TMPSelected

FROM TableB;

LOAD

[Project ID],

[Submitted Item ID],

If(Exists(TMPSelected, [Project ID] & [Submitted Item ID]), 'Y','N') as [Selected?]

FROM TableA;

topic Re: IF (Exists) statement in QlikView

IF (Exists) statement

Re: IF (Exists) statement