Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks...
it works