Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can someone open this attached qvw, copy and paste the load script into a reply here? We have qliksense cloud, and only macs, so no access to qlikview... and the answer to a an article that solves an issue we have is in that qvw.
Thank you!
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
LOAD @1,
@2,
@3
FROM
[http://qvtest:qvtest@www.rpostma.com/qvtest/qvtest.csv]
(txt, codepage is 1252, no labels, delimiter is ';', msq);
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
LOAD @1,
@2,
@3
FROM
[http://qvtest:qvtest@www.rpostma.com/qvtest/qvtest.csv]
(txt, codepage is 1252, no labels, delimiter is ';', msq);