transform

[#1]

Hi Guys,

Please help me to transform this table:

change book1 to book 2

Thanks

[CELAMBARASAN · Accepted solution]

Hi,

Use Generic load.

Data:

Generic LOAD

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

          @1,

     @2

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.

[#3]

Hi,

Thanks for replying,

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

Thanks