Load Where in Qlik Sense

[HJSchieder]

In Qlik-View I used following script and I tried to change it into Qlik-Sense but the where order does not work here.

How can I do the same in Qlik-Sense?

BT_INFO:
LOAD *;
SQL SELECT
BTI.NLFDKBNR,
SBAUREIHE,
ORDNR,
SMOTORVARNR,
SC_FARBE
FROM QSYSAUSW."BT_INFO" BTI
STORE BT_INFO INTO $(path)\BT_INFO.qvd;
DROP TABLE BT_INFO;

IBSVI_BT_INFO_MEASURE_REL:
LOAD *;
SQL SELECT
MEASURE_RELEVANT,
BTM.NLFDKBNR
FROM QSYSAUSW."IBSVI_BT_INFO_MEASURE_REL" BTM, QSYSAUSW."BT_INFO" BTI
WHERE (BTM.NLFDKBNR=BTI.NLFDKBNR);

STORE IBSVI_BT_INFO_MEASURE_REL INTO $(path)\IBSVI_BT_INFO_MEASURE_REL.qvd;
DROP TABLE IBSVI_BT_INFO_MEASURE_REL;

[Chanty4u · Accepted solution]

you can do like this

LOAD

field1,

field2

WHERE (BTM.NLFDKBNR=BTI.NLFDKBNR);
SQL SELECT  * FROM QSYSAUSW."IBSVI_BT_INFO_MEASURE_REL" BTM, QSYSAUSW."BT_INFO" BTI
;

[MayilVahanan]

Hi @HJSchieder 

Try like below

BT_INFO:
LOAD *;
SQL SELECT
NLFDKBNR,
SBAUREIHE,
ORDNR,
SMOTORVARNR,
SC_FARBE
FROM QSYSAUSW."BT_INFO" BTI;

IBSVI_BT_INFO_MEASURE_REL:

inner Keep
LOAD *;
SQL SELECT
MEASURE_RELEVANT,
NLFDKBNR
FROM QSYSAUSW."IBSVI_BT_INFO_MEASURE_REL" BTM;

STORE BT_INFO INTO $(path)\BT_INFO.qvd;
STORE IBSVI_BT_INFO_MEASURE_REL INTO $(path)\IBSVI_BT_INFO_MEASURE_REL.qvd;
DROP TABLE IBSVI_BT_INFO_MEASURE_REL;

DROP TABLE BT_INFO;

[NitinK7]

may be you can try like below

IBSVI_BT_INFO_MEASURE_REL:
LOAD *;
SQL SELECT
MEASURE_RELEVANT,
BTM.NLFDKBNR
FROM QSYSAUSW."IBSVI_BT_INFO_MEASURE_REL" BTM 

inner join

QSYSAUSW."BT_INFO" BTI

on

BTM.NLFDKBNR=BTI.NLFDKBNR ;

[HJSchieder]

Thanks a lot to all, with your help I found a solution !!