topic Data Processing with comand Previous in QlikView

Data Processing with comand Previous

tizianacaem — Thu, 03 Feb 2011 10:46:38 GMT

Hi all,

I have some production data to be processed.

Each work-order consists of several operations, indicated by a number, which is not necessarily a progressive continuum (eg work-order 100, operations 1,3,8 work-orders 101, operations, 1,5, 7 etc. ). There is a sequence number, which indicates the sequence in which the operations are done in the same work-order.

For each operation I have an end date but no start date. The start date of an operation, however, could be represented by the end date of the previous operation, within the same work-order.

I tried to insert the following statement in the script, but it doesn't work.

OPERATIONS:
load *
PREVIOUS (OPERATION_DATA_END) AS OPERATION_DATA_START;
LOAD *
FROM OPERATION.QVD (QVD) order by OPERATION_WORK_ORDER, OPERATION_NUMBRE_SEQUENCE;

Someone have any ideas???

thanks

Tiziana

Data Processing with comand Previous

Thu, 03 Feb 2011 11:26:50 GMT

Hi Tiziana,

The problem in this Order By command, you need to load a resident to use the command Order By, try this:


TMP_OPERATIONS:
LOAD *
FROM OPERATION.QVD (QVD) order by OPERATION_WORK_ORDER,OPERATION_NUMBRE_SEQUENCE;
OPERATIONS:
load
*,
PREVIOUS (OPERATION_DATA_END) AS OPERATION_DATA_START
RESIDENT TMP_OPERATIONS
order by OPERATION_WORK_ORDER,OPERATION_NUMBRE_SEQUENCE;
drop table TMP_OPERATIONS;

Data Processing with comand Previous

tizianacaem — Thu, 03 Feb 2011 12:42:07 GMT

Thanks, now it work correctly.

I just deleted the order by from the TMP_OPERATIONS.

Bye

Data Processing with comand Previous

Thu, 03 Feb 2011 12:50:43 GMT

Ok,

I forgot to remove the order by.