Hi,
I am trying to load information from an excel file(.xlsx), and I have formatted some of the contents, but found the following formulas no longer working on the new QV 11.
- Day
- Month
- Year
- Isnull
- Date
The following is my script.
LOAD b2_num,
b3_num,
text(mid(b3_num,7,8)) as CREFNO,
b2_submit,
date(das_date) as 'das date',
refund_amt,
cheque_dat,
cheque_num,
cancelled,
date(cancelled) as 'cancel date',
day(cancelled) as 'cancel day',
month(cancelled) as 'cancel month',
year(cancelled) as 'cancel year',
isnull(cancelled) as 'datenull',
reject_dat,
resub_date,
b3_date,
auditor,
client_ref,
expl,
justify,
submitted
FROM
(ooxml, embedded labels, table is mmi8);
but the output does not come out the way it was in QV 10.
Would you please help?
Thanks.
Sharon
