Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have got a table contains the following :
aanvullende gegevens:
persoon vraag antwoord
Bert favoriete kleur Blauw
Henk favoriete eten Hamburger
Bert beste film Ocean's eleven
Bert favoriete eten Pasta
Henk beste film TED
Jan beste film Crease
Jan favoriete eten Spinazie
Henk favoriete kleur Rood
Jan favoriete kleur Geel etc
I want to load te table in my script with the following result
Persoon Favoriete Kleur Favoriete Eten Beste film
Jan Geel Spinazie Crease
Henk Rood Hamburger Ted
Bert Blauw Pasta Ocean's eleven.
Who can help me? Thanks ahead
This could be done with The Generic Load
- Marcus
or in the front end, using a pivot table, if that is suitable.
regards
Marco
Hi,
If you want to integrate the seperate tables created by the generic load, as already suggested by Marcus, into one, you could do so like this:
tabAanvullendeGegevens:
LOAD * INLINE [
persoon, vraag, antwoord
Bert, favoriete kleur, Blauw
Henk, favoriete eten, Hamburger
Bert, beste film, "Ocean's eleven"
Bert, favoriete eten, Pasta
Henk, beste film, TED
Jan, beste film, Crease
Jan, favoriete eten, Spinazie
Henk, favoriete kleur, Rood
Jan, favoriete kleur, Geel
];
tabMain:
LOAD Distinct persoon Resident tabAanvullendeGegevens;
tabTemp:
Generic LOAD * Resident tabAanvullendeGegevens;
DROP Table tabAanvullendeGegevens;
FOR i = NoOfTables()-1 to 0 STEP -1
LET vTable=TableName($(i));
IF WildMatch('$(vTable)', 'tabTemp.*') THEN
LEFT JOIN (tabMain) LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
ENDIF
NEXT i
Using some wonderful code provided by rwunderlich:
http://qlikviewcookbook.com/2010/05/use-cases-for-generic-load/
hope this helps
regards
Marco
Thanks, this is what i ment