columnfields as new columns

[#1]

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

[marcus_sommer]

This could be done with The Generic Load

- Marcus

[MarcoWedel]

or in the front end, using a pivot table, if that is suitable.

regards

Marco

[MarcoWedel]

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

[#5]

Thanks, this is what i ment