Script Load issue

[jagjivvt]

Hi

i need to load the below script and need to separate make further tables based on the Bill_Rate_Type, there are 54 rate types. the current load is in row and need to change that to column. Thanks

LOAD

     [Consolidated Invoice Code],

     [Consolidated Invoice ID],

     [Invoice ID],

     [Worker ID],

     [Invoice Line Item End Date],

     Bill_Rate ,

     Bill_Hrs ,

     Bill_Sub_Total ,

     Bill_Rate_Type

FROM

(qvd);

Vijay    

[Peter_Cammaert]

You may be in need of a reverse CROSSTABLE LOAD. That one is called a GENERIC LOAD which turns rows into columns (initially in different tables).

For more information and exmaples, see here: Generic ‒ QlikView