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,
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?
