Sorry i write very fast and made a lto of mystakes and also copy paste i see go bad.
So more easily i have one excel file with a lot of columns.
I one Qlik i click InsertScript and load the excel file in 2 ways i see on the net so far:
Load Table and finish or connect ODBC adn put user,pass and select there excel and what column to show on the Qlik screen.
After i do that i go Insertscript again to make Select and other stuff i need in normal SQL that i know and you see up code used in both cases select fail when i reload .
Its strange i am used to simple way create table ... select from table i can see it and the result of the query ,but here i am lost at see no command and i am doing somethign wrong but can even see what in the error given as a hint.