Load one row

[farolito20]

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;

[#2]

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.