Variable Assignment

[#1]

Hi,

I want to assign the value generated from the below load statement in to a variable name as Rec, pls provide me the script to be written for acheiving these task

LOAD MAX(RECORD_NO) from TEST.QVD

Thanks,

Arun

[Miguel_Angel_Baeyens]

Hello Arun,

Rename first the field so you can use it later

LOAD MAX(RECORD_NO) AS MAX_RECORD from TEXT.QVD

I'm using the following

LET vMaxRecordNo = FieldValue('MAX_RECORD', 1);

Peek() or even LookUp() will do as well.

Regards.

[#3]

Hi Arun,

here you are

DATA:
Load
Max(Reord_No) as MaxRecordNo
From Test.qvd (qvd);

Let vRec = Peek('MaxRecordNo', 0, 'DATA');

Good luck!

Rainer