topic Re: SQL or QV Scripting issue in QlikView

SQL or QV Scripting issue

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

Hi All,

Have 1 scenario.

Emp Table1: 100 records

Id Fname

Emp Table 2: 20 records

Id Fname

Now,

1. need to write SQL to fetch only 80 records

2. Write QV code to fetch only 80 records.

Please help.

Re: SQL or QV Scripting issue

kaushiknsolanki — Tue, 06 Mar 2018 04:56:23 GMT

Hi,

What you need is Qlik Exists function. Try below script.

Table2:

Load IdFrame

From xyz;

Table1:

Load IdFrame

From PQR where not exists(IdFrame);

Regards,

Kaushik Solanki

Re: SQL or QV Scripting issue

vishsaggi — Tue, 06 Mar 2018 05:02:22 GMT

What is the actual script you are using where you have this issue?

May be you can try like

EMPTab1:

First 100 Load *;

SQL SELECT ID, Fname FROM yourtablename1;

EMPTab2:

First 20 Load *;

SQL SELECT ID, Fname FROM yourtablename2;

Noconcatenate

FinalTab:

First 80 LOAD * Resident EMPTab1;

Drop Table EMPTab1;

Re: SQL or QV Scripting issue

shiveshsingh — Tue, 06 Mar 2018 05:58:58 GMT

What logic you want here?

Are 100 and 20 records having same value?

Can you share the script that you are using? on what logic you want to select 80 records?

Re: SQL or QV Scripting issue

Anonymous — Tue, 06 Mar 2018 11:21:32 GMT

Interview Question for Project. The records in the Table must be common no First Load or something like that.

Re: SQL or QV Scripting issue

Anonymous — Tue, 06 Mar 2018 11:22:38 GMT

Thank you Kaushik. I told the same ans but I guess the Interviewer was not satisfied or I might had lacked the confidence even if it was correct.

Re: SQL or QV Scripting issue

vishsaggi — Tue, 06 Mar 2018 13:55:20 GMT

‌nnot clear can you elaborate a little?