topic Job Trace in QlikView

Job Trace

Wed, 22 Apr 2015 22:03:12 GMT

Please see attached document, by processing transactions I moving on from one job number to other, I would like to know I can map from first line to all related transactions.

Please advise

Re: Job Trace

Anonymous — Wed, 22 Apr 2015 22:46:38 GMT

Sorry but what is the desired output that you are looking for?

Re: Job Trace

Thu, 23 Apr 2015 06:47:25 GMT

Hi I need to add trace column, trace should represent fist job id even we move product to new stage (new job id).

Thanks

Re: Job Trace

Anonymous — Thu, 23 Apr 2015 13:49:02 GMT

Try this,

DATA:

LOAD * INLINE [

PROD, TRAN TYPE, LOT NO, QTY, JOB ID

P001, ISSUE, 7000, -100, J0001

K001, BOOK, T00001, 50, J0001

K001, ISSUE, T00001, -50, J0001

L001, BOOK, T00002, 60, J0001

L001, ISSUE, T00002, -60, J0002

Y001, BOOK, T00003, 150, J0002

];

left join (DATA)

LOAD Distinct

PROD,

PROD AS PROD2,

[JOB ID] as TRACE

Resident DATA

WHERE NOT Exists(PROD2,PROD)

ORDER BY PROD,[JOB ID] ASC

;

drop field PROD2;

Re: Job Trace

buzzy996 — Thu, 23 Apr 2015 14:26:24 GMT

are looking for this?