Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ellrbeckm
Contributor
Contributor

Pulling a table name from a table to change based on language selection

Given

[languages]:
LOAD * Inline [
language_id, languagedisplayname
1,English
2,Español
3,Italiano
4,中文普通话
5,中国官话
6,한국어
7,Português
8,日本語
];

[table name]:
LOAD * Inline [
language_id, table_id, table_name
1,99, Table A English
2,99, Table A Spanish
3,99, Table A Italian
4,99, Table A Chinese
5,99, Table A Chinese
6,99, Table A Korean
7,99, Table A Portuguese
8,99, Table A Japanese
1,100, Table B English
2,100, Table B Spanish
3,100, Table B Italian
4,100, Table B Chinese
5,100, Table B Chinese
6,100, Table B Korean
7,100, Table B Portuguese
8,100, Table B Japanese
];

 

I then set the table title using this set expressions

=concat({<table_name = P(table_name),table_id={'99'}>}table_name)

Would you do this in a different manner?

 

Labels (1)
0 Replies