topic Re: Flag if Value exists in another table in QlikView

Flag if Value exists in another table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have two tables in my sql server, Table A and Table B. I am creating a qvw/qvd file and pulling Table A in it. I want to create a Flag field to identify which of the values of a field called ID were existing in Table B. I do not have to necessarily pull in data from Table B.

I just need a Flag to identify the ones that existed and the ones that didn't exist.

Could anyone please suggest how to do it.

Thank You.

Re: Flag if Value exists in another table

marcus_sommer — Fri, 05 Oct 2018 06:34:31 GMT

You could try something like this:

B: load distinct ID from B;

A: load *, -exists(ID) as Flag from A;

drop tables B;

- Marcus

Re: Flag if Value exists in another table

Sergey_Shuklin — Fri, 05 Oct 2018 09:27:07 GMT

Hello!

You can use join for achieving this

Re: Flag if Value exists in another table

Anonymous — Mon, 08 Oct 2018 01:55:47 GMT

Worked perfectly fine for me.

Thank You.

Re: Flag if Value exists in another table

Anonymous — Mon, 08 Oct 2018 01:57:17 GMT

Hi,

Thank you for your response.

I had tried a similar solution but couldn't get the right numbers.