topic Crosstable/generic load settings in QlikView

Crosstable/generic load settings

Peony — Tue, 25 Jul 2023 08:45:24 GMT

Hi all.
I have a table similar to this:
Translate:
Load *Inline [
source, ENG, GER, 3_let_code
s1, English, Deutsch, head_1
s1, Select your language, Bitte wählen Sie Ihre Sprache, head_2
s1, Customer Feedback, Kundenfeedback, head_3

];

And I need to make somehow crosstable load to receive this result:

head_1	head_2	head_3	3_let_code
English	Select your language	Customer Feedback	ENG
Deutsch	Bitte wählen Sie Ihre Sprache	Kundenfeedback	GER

And unfortunately I can't get how to get desired result. Maybe someone could help me with the idea how to deal with this issue?

Re: Crosstable/generic load settings

cwolf — Tue, 25 Jul 2023 20:42:27 GMT

Translate: Load * Inline[ source,ENG,GER,3_let_code s1,English,Deutsch,head_1 s1,Selectyourlanguage,BittewählenSieIhreSprache,head_2 s1,CustomerFeedback,Kundenfeedback,head_3 ]; // 1. Build a table with all languages from fieldnames for i=1 to NoOfFields('Translate') fn=FieldName(i,'Translate') if not Match('$(fn)','source','3_let_code') then LangTab: load '$(fn)' as Language AutoGenerate 1; endif next i // 2. Generic load of all languages for each lang in FieldValueList('Language') tmp: Generic LOAD '$(lang)' as Language, "3_let_code", "$(lang)" Resident Translate; next lang // 3. Join all generated tables for i=NoOfTables() to 1 step -1 let tn=TableName($(i)); if WildMatch('$(tn)','tmp.*') then left join(LangTab) load * resident "$(tn)"; drop table "$(tn)"; end if next i // Finally DROP table Translate; RENAME Field Language to "3_let_code";

Re: Crosstable/generic load settings

Peony — Mon, 31 Jul 2023 08:05:50 GMT

Hey @cwolf Thank you for a fresh ideas you shared😊. This solution definitely forks for me.