Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
Help me to use it :
SELECT
field1,
field2
from table1
where field1 in (load field from table2.qvd(qvd));
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.
or maybe where field1 in (select from excel)
Try this
Temp:
Load
Field as Field1,
From Table2.qvd ;
Final:
Select Field1,
Field2
From Table1 where exists(Field1);
Drop table Temp;
T1: load field as field1 from table2.qvd(qvd));
left join(T1)
SELECT
field1,
field2
from table1
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
You can use Keep here
Final:
Load Field1,
Field2
From table 2;
Left Keep
Temp:
Load Field as Field1
From Excel;
Drop table Temp;
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.
it will join field 1 from table2.qvd with field 1 from table1?
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.
THANK YOU!