Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
i have a SQl source, where tables with "Umlaute" exists.
Because the numbers and the names of the SQL-table are variable, i load the tabel names with an select order into a qlik table.
In this Qlik-table
i see the storige-place and the name of the SQL-Table.
Then i want to load all fields of all SQL-tables in one Qlik-table.
I use this script:
for each WEBBASKETXX in FieldValueList('_15WEBBASKETNAME')
Concatenate
select
*,
'$(WEBBASKETXX)' as _15WEBBASKETXX
from $(WEBBASKETXX);
next WEBBASKETXX;
But i get this error message, when the name of the SQL- table contents a "Umlaut"
If there is no "Umlaut" in the name the script works.
How can i convince Qlik to read the table?
Thanks
it´s solved.
i did an beginner error! Sorry!