How to add

[subbareddykm]

Hi all , here ,i have question,

I,m tring to get this task using qlikivew.

i have data like this. What is my requirement is

First column should be freedze and for second column i want like reverse cross table.like below

if any column adds in second column it should gointo column level i.e should create new column.

Means my table should be like this

Load

      [Emp Id],

     Test,

     Column 1

     Column 2

     Column 3.......... and so on

From .................

Is irt possible do it ?

Help me guyzzz

[settu_periasamy · Accepted solution]

Have yoy tried with generic load..?

Use cases for Generic Load | Qlikview Cookbook

[subbareddykm]

No, I don't know how to use that,

Can check with my data...?

[settu_periasamy]

May be Check the Attachment

Script:

T1:
LOAD [Emp ID], 
     Test
FROM
generic_test.xlsx
(ooxml, embedded labels, table is Sheet1);


T2:
Generic LOAD [Emp ID],Test,'' as test Resident T1;


CombinedGenericTable:
Load distinct [Emp ID] Resident T1;

FOR i = NoOfTables()-1 to 0 STEP -1
  LET vTable=TableName($(i));
  IF WildMatch('$(vTable)', 'T2.*') THEN
  LEFT JOIN ([CombinedGenericTable]) LOAD * RESIDENT [$(vTable)];
  DROP TABLE [$(vTable)];
  ENDIF
NEXT i


DROP Table T1;