Translations in the Load Script

crichter14 — Sat, 16 Nov 2024 18:00:57 GMT

My company is doing training sessions and each one has a Session_Name. They have Session_ID's but those aren't unique.

Some of the names for the same course(s) are in German and Polish. I need a way, in the load script, to translate from German to English, Polish to English. I can use an if statement, but I'm afraid they will keep adding new sessions and new names so I need a way to let them put the data in excel sheet and translate it in the load script.

I know there are ways to do it in Qlik View, but I need Qlik Sense please.

I'm considering a mapping load from an excel file - but I've not used one before. Can someone help me map it out - or point me to Qlik Sense post?

Thank you!

IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'LAGERBESTAND NEU ERFINDEN: LAGER-STRATEGIEN', 'REINVENTING INVENTORY: STOCK STRATEGIES',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'PONOWNE SPOJRZENIE NA ASORTYMENT: STOCK STRATEGIES', 'REINVENTING INVENTORY: STOCK STRATEGIES',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'AUFSTEHEN UND WACHSEN: ERFOLGREICHE VERÄNDERUNG', 'RISE AND THRIVE: LEADING CHANGE',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'WZRASTAJ I ROZWIJAJ SIĘ : WIODĄCA ZMIANA', 'RISE AND THRIVE: LEADING CHANGE',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'DIE ZUKUNFT IST JETZT: GERÜSTET FÜR DEN ERFOLG', 'THE FUTURE IS NOW: EQUIPPED FOR SUCCESS',
IF(UPPER(SUBFIELD("Session Title",' - ',1)) = 'PRZYSZŁOŚĆ JEST TERAZ: BĄDŹ PRZYGOTOWANA NA SUKCES', 'THE FUTURE IS NOW: EQUIPPED FOR SUCCESS',
UPPER(SUBFIELD("Session Title",' - ',1))))))))
AS SESSION_NAME,

Re: Translations in the Load Script

chrismarlow — Mon, 05 Oct 2020 16:28:03 GMT

Hi,

I think mapping load is the the same in QlikView script vs Qlik Sense, detailled here;

https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/use-mapping-as-alternative-join.htm

So you would do something like in the toy application attached.

Cheers,

Chris.

Re: Translations in the Load Script

crichter14 — Mon, 05 Oct 2020 17:00:20 GMT

Exactly what I needed Chris! I did not want to hard code this. Someone explained Mapping Load to me, like a vlookup. I've always had a hard time with the syntax. ApplyMap('Translation', phrase, null()) as Translation; So let me ask you this. In this apply map is null() the default if there's no match?

Thank you so much!

topic Re: Translations in the Load Script in App Development

Translations in the Load Script

Re: Translations in the Load Script

Re: Translations in the Load Script