Script Load issue

jagjivvt — Fri, 02 Feb 2018 08:45:37 GMT

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

Re: Script Load issue

Peter_Cammaert — Fri, 02 Feb 2018 10:39:38 GMT

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

topic Script Load issue in QlikView

Script Load issue

Re: Script Load issue