Translations in the Load Script

[crichter14]

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!

c

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,

[chrismarlow · Accepted solution]

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-mappi...

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

Cheers,

Chris.

[crichter14]

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!