Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi evereybody,
I need some help, cause i want to select some data from RS_INDIVIDUAL_BILLING where OID_METER are in [lib://Dados/MI/Leituras/Consumo/Condominios/Carga_Consolidada_20170424.qvd].
How can i do that?
LOAD
OID_METER
FROM
[lib://Dados/MI/Leituras/Consumo/Condominios/Carga_Consolidada_20170424.qvd]
RS_INDIVIDUAL_BILLING:
LOAD
*
;
SQL
SELECT
*
FROM RS_INDIVIDUAL_BILLING
WHERE MONTH1>='20/04/2017' AND OID_METER = ??????;
Thank you
LOAD OID_METER
FROM [lib://Dados/MI/Leituras/Consumo/Condominios/Carga_Consolidada_20170424.qvd]
RS_INDIVIDUAL_BILLING:
LOAD *
where exists (OID_METER)
;
SQL
SELECT *
FROM RS_INDIVIDUAL_BILLING
WHERE MONTH1>='20/04/2017';
LOAD OID_METER
FROM [lib://Dados/MI/Leituras/Consumo/Condominios/Carga_Consolidada_20170424.qvd]
RS_INDIVIDUAL_BILLING:
LOAD *
where exists (OID_METER)
;
SQL
SELECT *
FROM RS_INDIVIDUAL_BILLING
WHERE MONTH1>='20/04/2017';
I don't believe you can do it directly in your SQL statement. But here is one option:
LOAD
OID_METER
FROM
[lib://Dados/MI/Leituras/Consumo/Condominios/Carga_Consolidada_20170424.qvd]
RS_INDIVIDUAL_BILLING:
LOAD
*,
where exists(OID_METER)
;
SQL
SELECT
*
FROM RS_INDIVIDUAL_BILLING
WHERE MONTH1>='20/04/2017';
Hi Massimo,
but how the QS will distinguish OID_METER from Carga_Consolidada_20170424 that OID_METER from RS_INDIVIDUAL_BILLING? Cause both have this Field.
Hi Wallo,
I have the same question about that from Massimo answer.
How the QS will distinguish OID_METER from Carga_Consolidada_20170424 that OID_METER from RS_INDIVIDUAL_BILLING? Cause both have this Field.
Ahh i understand now, i read the help of QS:
" Returns -1 (True) if the value of the field in the current record already exists in any previously read record that contains this field."
1)
Qlik loads the values of OID_METER from qvd, Carga_Consolidada_20170424
2)
Qlik will load the values of OID_METER from RS_INDIVIDUAL_BILLING (SQL .... FROM ....WHERE).
You get all OID_METER values from the database but in the LOAD (LOAD * where exists(OID_METER)) Qlik will only get the value of OID_METER already loaded in step 1
Wallo, i read the qlik sense help to understand the answer and now i think that did it.
" Returns -1 (True) if the value of the field in the current record already exists in any previously read record that contains this field."
If you got the answer