Resident table inner join issue 2

[#1]

Hi Guys,

I have this script where where i am loading SalesReceiptLine and
SalesReceipt and trying to join then common field name TxnID but when i check NoOfRows for Temp_Table then it shows null.

NoConcatenate

[SalesReceipt]:

LOAD TxnID,

'Sales Receipt' as TxnType,

CheckNumber,

Date(TxnDate, 'MM/DD/YYYY') as TxnDate,

DepositToAccountListID,

DepositToAccountFullName

FROM

[$(Path)$(_CompFileName)_v_SalesReceipt.qvd]

(qvd);

NoConcatenate

[SalesReceiptLine]:

Load TxnID,

TxnLineID,

AccountFullName,

Amount

FROM

[$(Path)$(_CompFileName)_v_SalesReceiptLine.qvd]

(qvd);

NoConcatenate

[Temp_Table]:

LOAD

TxnID,

TxnType,

CheckNumber,

TxnDate,

DepositToAccountFullName,

DepositToAccountListID as ListID

Resident SalesReceipt;

inner join (Temp_Table)

Load

TxnID,

TxnLineID,

AccountFullName,

Amount

Resident SalesReceiptLine;

let v = NoOfRows(Temp_Table);

if Not isNull (NoOfRows(Temp_Table)) then

store Temp_Table into 'c:\Temp2.qvd';

ENDIF

Thanks,

Saurabh

[swuehl · Accepted solution]

Try

let v = NoOfRows( 'Temp_Table' );

If this does not help, try to create your tables step by step, and check tables linked correctly by TxnID.

[#3]

Thanks...

it works