How to check data dynamically ,while loading it in Qlikview ?

Mon, 12 Jan 2015 12:15:36 GMT

i am debugging the QV script, i need to know whether we can see what data is loaded into my tables.

example:

emp_table:

sql select empId, empSalary from empTable

where empId >400.

now i wanna check what data is stored in my "emp_table" in QlikView?

thanks in advance,

Re: How to check data dynamically ,while loading it in Qlikview ?

peter_turner — Mon, 12 Jan 2015 12:25:47 GMT

Hello Anjan,

It’s not possible to see a preview of the data inside a table during the load, but there are some options available to you.

You'll be able to see in the reload log file which fields and number of rows were loaded into your table
Adding trace statements to output variables or comments
Using the Exit Script command to stop your script at a selected point, you'll then be able to see the data in QV from the table viewer.
After your table load, save the data into a QVD and you could open this and see what was loaded at that point in time.

There are lots of other ways depending on how you develop and what you need todo.