I have a question about using SQL in QlikView:
I have these 2 queries and I want to merge them:
1/ select *
2/ select 'TOTO' as Name
and I want to do something like :
select *,'TOTO' as Name
but of course this doesn't work.
Someone have a idea?
Why doesn't it work?
I have this error:
SQL##f - SqlState: S1000, ErrorCode: 923, ErrorMsg: [Oracle][ODBC][Ora]ORA-00923: FROM keyword not found where expected
Why don't you just do:
'TOTO' as Name;
I need in this file to select and store,
not to load!
And you dont have another idea using the select?or to replace the '*' ?
I'm a bit lost as to what you're doing actually.
You want to load a table and add a field called Name containing the string 'TOTO'.
Then you want to store this table.. as a QVD I assume?
Ok,i will be more explicit:
I have 2 qwv files, 1 to select the fields I need (in this case all the fields and the field 'TOTO')
and another fields to load the fields (maybe 2 fields and 'TOTO') .
And Yes i store them in a qvd file.
So i need to use the select to dont make connection with tables.
Retrieving data ...