I'm new in Qlik script, and I'm having problems creating a table using qlik, let me try to explain... i want to do this (SQL) but on qlik
I think that I should use the LOAD statement, but i can't figure it out how
Do you want to create a table with just the headers?
If so, you can use something like this (no need to declare data types)
LOAD * INLINE
userid, userfunction, courseid ...
If you're loading from an existing source, it would be something like this:
i'm using an ODBC connection to connect to my database, the goal is to create a temporary table with the columns i mentioned,then i will do some joins and filters to finnaly have a report about the past month
FROM SQL Connection....