Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
FrankGrimm
Partner - Creator
Partner - Creator

german code page

Hello together,

 

i have a SQl source,  where tables with "Umlaute" exists.

FrankGrimm_2-1669203387024.png

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 

FrankGrimm_0-1669208685882.png

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"

FrankGrimm_0-1669203233697.png

If there is no "Umlaut" in the name the script works. 

How can i convince Qlik to read the table?

Thanks

Labels (2)
1 Solution

Accepted Solutions
FrankGrimm
Partner - Creator
Partner - Creator
Author

it´s solved.

i did an beginner error! Sorry!

View solution in original post

1 Reply
FrankGrimm
Partner - Creator
Partner - Creator
Author

it´s solved.

i did an beginner error! Sorry!