Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hola!!
Quiero realizar una carga condicional desde el script de Qlik sense. Tengo una BD con 5 años cargados, pero solo deseo cargar del año 3 en adelante. ¿Como puedo realizar esta condición en Qlik Sense Desktop en el Scrip de carga?
El archivo a cargar es un qvd.
Espero me puedan ayudar, Muchas Gracias!!
Hi,
there are multiple ways in which you can filter data during load
1) Specify a Where Clause
Load *
From SomeQvd.qvd(qvd)
WHERE Date>yearstart(today(),-2)
2) INNER KEEP or INNER JOIN
autogenerate a table for all dates from last 3 year to todate
test:
Load date(yearstart(today(),-2)+iterno()) as DATE
AutoGenerate 1
While YearStart(today(),-2)+iterno()<=today();
INNER KEEP(test)
load Dim1,Dim2,DATE
From SomeQvd.qvd(qvd);
3) Use Where Exists(FIELDNAME) for Optimized load from QVD source
test:
Load date(yearstart(today(),-2)+iterno()) as DATE
AutoGenerate 1
While YearStart(today(),-2)+iterno()<=today();
load Dim1,Dim2,DATE
From SomeQvd.qvd(qvd)
WHERE EXISTS(DATE);
Drop table test;
Hi,
there are multiple ways in which you can filter data during load
1) Specify a Where Clause
Load *
From SomeQvd.qvd(qvd)
WHERE Date>yearstart(today(),-2)
2) INNER KEEP or INNER JOIN
autogenerate a table for all dates from last 3 year to todate
test:
Load date(yearstart(today(),-2)+iterno()) as DATE
AutoGenerate 1
While YearStart(today(),-2)+iterno()<=today();
INNER KEEP(test)
load Dim1,Dim2,DATE
From SomeQvd.qvd(qvd);
3) Use Where Exists(FIELDNAME) for Optimized load from QVD source
test:
Load date(yearstart(today(),-2)+iterno()) as DATE
AutoGenerate 1
While YearStart(today(),-2)+iterno()<=today();
load Dim1,Dim2,DATE
From SomeQvd.qvd(qvd)
WHERE EXISTS(DATE);
Drop table test;
Muchas gracias!!