Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am new to Qliksense how to perform the preceding load in qliksense?
Hi,
Check below example for preceding load
Data:
LOAD ///// Preceding Load, the TransactionDate field already formatted in initial load so there is no need to format in Month & Year fields.
*,
Month(TransactionDate) AS Month,
Year(TransactionDate) AS Year;
LOAD
TransactionID,
Date(Date#(TransactionDate, 'MMM-YYYY')) AS TransactionDate
FROM DataSource;
Check in Google or QV Community you will get n number of examples.
REgards,
Jagan.
Hi,
Check below example for preceding load
Data:
LOAD ///// Preceding Load, the TransactionDate field already formatted in initial load so there is no need to format in Month & Year fields.
*,
Month(TransactionDate) AS Month,
Year(TransactionDate) AS Year;
LOAD
TransactionID,
Date(Date#(TransactionDate, 'MMM-YYYY')) AS TransactionDate
FROM DataSource;
Check in Google or QV Community you will get n number of examples.
REgards,
Jagan.
this is a good start for preceding load
Hi Jagan,
Thanks for your reply by using ADD function how can perform the Partial reload in qlik sense
Thanks for your reply by using ADD function how can perform the Partial reload in qlik sense