Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I just pull the first line from a table ?
I tried "SELECT TOP 1 * FROM [TableName]" ... didn't seem to like the 1.
Even better, How would I just pull the column list ?
Even better than that, where is a user manual for SQL commands that work in QlikView
Use the First prefix in a preceding load.
[TableName]:
First 1
LOAD *;
SQL SELECT * FROM [TableName];