topic transform in QlikView

transform

Sun, 14 Jul 2013 00:02:50 GMT

Hi Guys,

Please help me to transform this table:

change book1 to book 2

Thanks

CELAMBARASAN — Sun, 14 Jul 2013 01:11:25 GMT

Hi,

Use Generic load.

Data:

Generic LOAD

Ceil((Rowno()/3)) AS Rowno,

@1,

FROM

C:\Users\Celambarasan\Desktop\Book1.xls

(biff, no labels, table is Sheet1$);

Script is based on your excel and qvw attached for your reference.

Regards,

Celambarasan.

Sun, 14 Jul 2013 02:16:04 GMT

Hi,

Thanks for replying,

I can not load Biff . Do you have any idea?

Thanks