Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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!