topic Transform Table in QlikView

Transform Table

Wed, 14 Mar 2012 16:04:07 GMT

Hi, I need convert the table1 in the table2 in script, can help me please

Thanks.

swuehl — Wed, 14 Mar 2012 20:31:49 GMT

Maybe like this:

KEYSEC:

LOAD * INLINE [

ID, name, key, Sec

1, A, ,1AS

1, A, 1AK,

3, C, ,3CS

3, C, 3CK,

4, D, 4DK,

];

NOCONCATENATE LOAD

ID, name,

maxstring(key) as key,

maxstring(Sec) as Sec

Resident KEYSEC group by ID,name;

drop table KEYSEC;

Thu, 15 Mar 2012 10:24:47 GMT

Thanks a lot swuehl.