Load one row

farolito20 — Fri, 28 Dec 2012 17:47:10 GMT

How can I load the last row of this condition? I just need the last one.

LOAD

t_bpid,

t_nama,

t_ccur,

Resident DimOld

Where exists (Checksum2, Checksum) and t_bpid = $(vCustomerNumber) and MostRecent=1;

Re: Load one row

Fri, 28 Dec 2012 21:39:13 GMT

Hi,

You can use the NoOfRows() Function:

First you Load the table an then :

LET a = NoOfRows('Data');

and after that you can use the:

Where RecNo()=$(a);

e.g

//***********************************************//

Data:

Load

INLINE

[ID,EbeneID,Text

1,1,some Text ID1

2,2,some Text ID2

3,3,some Text ID3

4,2,some Text ID4

5,1,some Text ID5

6,2,some Text ID6

7,3,some Text ID7

8,1,some Text ID8

] ;

LET a = NoOfRows('Data');

Data2:

NoConcatenate

LOAD

ID as LastID,

EbeneID as LastEbeneID,

Text as LastText

Resident Data

Where RecNo()=$(a);

//***********************************************//

Hope it help,

Regards,

Yigal.