Hello, I am new to QlikView. I have wrote a script to connect to a ODBC datasource and loading data from a table which I am storing as a csv file.
The script is loading all rows from the table. However I need to implement a logic where data from the start of the month till yesterday needs to be stored. How can I achieve this through the script? I'd appreciate any pointers.
Here is how my script looks like.
ODBC CONNECT TO hivesource; CHECK: LOAD table1.date AS LDATE, table1.name AS LNAME; SQL SELECT date, name from schema.table1; //both fields are string datatype
OUT: Load LDATE AS ODATE, LNAME AS ONAME RESIDENT CHECK; Store OUT into out.csv (TXT);