topic Re: How to add in QlikView

How to add

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to add

settu_periasamy — Wed, 11 May 2016 15:42:16 GMT

Have yoy tried with generic load..?

Use cases for Generic Load | Qlikview Cookbook

Re: How to add

subbareddykm — Wed, 11 May 2016 15:44:30 GMT

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

Can check with my data...?

Re: How to add

settu_periasamy — Wed, 11 May 2016 16:16:50 GMT

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;