german code page

FrankGrimm — Wed, 23 Nov 2022 13:11:08 GMT

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

Re: german code page

FrankGrimm — Wed, 23 Nov 2022 13:34:40 GMT

it´s solved.

i did an beginner error! Sorry!