rowno () in script side depending upon specific columns

[#1]

HI All,

I want to write RowNO () funcion in script side depending upon Workcenter , Funcion Location

Administrator

[jagannalla]

Hi,

Try this, but what is the calculation for Diff ?

T:

LOAD Workcenter,[Funcional Location],Text(Date) as Date,AutoNumber(RecNo(),Workcenter) as Seq;

LOAD * INLINE [

    Workcenter, Funcional Location, Date, Exp

    A, X, 02/28/2014,10

    B, Y, 03/12/2014,20 

    C, X, 03/20/2014,30

];

LOAD Date,

if(not IsNull(Peek(Date)),Date&'-'&Peek(Date)) as PrDate

Resident T

Order By Date

;

[MK_QSL]

PFA

[#4]

Hi Manish,

Please find an attachment file. In that Output column is my expected output.

[MK_QSL]

attachment is missing !

[#6]

HI Manish,

Please find an attachment in that I want Output column as expected ouptput.

BUt I want it script side.

[#7]

Hi Manish,

Please find an attachment. I want to do it script side.

[#8]

Hi All,

Please find an attachment I want output column in script side,.