topic Re: qvd in QlikView

qvd

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

Hello!

Help me to use it :

SELECT
field1,

field2

from table1

where field1 in (load field from table2.qvd(qvd));

Re: qvd

denis115 — Fri, 19 Jan 2018 08:06:18 GMT

or maybe where field1 in (select from excel)

Re: qvd

sasikanth — Fri, 19 Jan 2018 08:35:38 GMT

Try this

Temp:

Load

Field as Field1,

From Table2.qvd ;

Final:

Select Field1,

Field2

From Table1 where exists(Field1);

Drop table Temp;

Re: qvd

shiveshsingh — Fri, 19 Jan 2018 08:36:12 GMT

T1: load field as field1 from table2.qvd(qvd));

left join(T1)

SELECT
field1,

field2

from table1

Re: qvd

denis115 — Fri, 19 Jan 2018 08:42:06 GMT

will it join fileds from table1 and table 2?

if yes I dont need this, I want to select only some data from table 1 and for this I ve created a qvd file that have field 1 like I need

Re: qvd

sasikanth — Fri, 19 Jan 2018 09:30:49 GMT

You can use Keep here

Final:

Load Field1,

Field2

From table 2;

Left Keep

Temp:

Load Field as Field1

From Excel;

Drop table Temp;

Re: qvd

Peter_Cammaert — Fri, 19 Jan 2018 09:37:01 GMT

You can use an INNER JOIN with a filter table, or the QlikView Exists() function (requires more steps since you start with a SQL SELECT) or an ApplyMap() (also less than optimal due to the SQL SELECT). The INNER JOIN is easiest, I think:

Table:

LOAD DISTINCT Field AS Field1

FROM Table2.QVD (QVD);

INNER JOIN (Table)

SQL SELECT Field1, Field2

FROM "Table1";

Leaves no traces, no cleanups to do. Just the data you want.

Re: qvd

denis115 — Fri, 19 Jan 2018 11:08:07 GMT

it will join field 1 from table2.qvd with field 1 from table1?

Re: qvd

Peter_Cammaert — Fri, 19 Jan 2018 11:27:01 GMT

You do understand how a JOIN works, don't you? All fields with identical names will cause their values to be matched. An INNER JOIN will reduce Table2 by keeping only those Field1 rows that have corresponding Field1 values in Table1.

Matching fields will not have their values concatenated.

Re: qvd

denis115 — Fri, 19 Jan 2018 12:17:21 GMT

THANK YOU!