Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, brand new user here. I have the following script.
LOAD:
FINANCIAL_YEAR,
AMOUNT
FROM
(qvd)
WHERE FINANCIAL_YEAR = '2020-21'
;
How do I update it to load both 2020-21 and 2019-20?
may be like this
LOAD:
FINANCIAL_YEAR,
AMOUNT
FROM
(qvd)
WHERE Match(FINANCIAL_YEAR , '2019-20' ,'2020-21')
may be like this
LOAD:
FINANCIAL_YEAR,
AMOUNT
FROM
(qvd)
WHERE Match(FINANCIAL_YEAR , '2019-20' ,'2020-21')
Yes, that did it! Thank you!
please mark it as correct answer