Split your data into two streams based on batch ID (Transformer stage).
The txnID value on each output link is given by the system variable @OUTROWNUM.
Done.
get the batchid and transaction id for each transaction
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 15
- Joined: Fri Nov 21, 2008 12:41 am
[quote="ray.wurlod"]Split your data into two streams based on batch ID (Transformer stage).
The txnID value on each output link is given by the system variable @OUTROWNUM.
Done. ...[/quote]
I am using the Websphere datastageTX(Transfermation extender),I dont have the option to use the OUTROWNUM function here.
I am trying in this way,
F_Cnt(NUMBERTOTEXT(COUNT(EXTRACT(DebitAccNo Field:Transaction:Payment:PbtIn,DebitAccNo Field:Transaction:Payment:PbtIn="6548798277"))),INDEX($))
The number here i have asssigned is one of the account number(6548798277),
Insted of passing the account number i to want pass one variable(s),which contails all unique
account numbers but the loop is not working as i expected(as per my requirement).
I would appricieate if have any suggestions.
The txnID value on each output link is given by the system variable @OUTROWNUM.
Done. ...[/quote]
I am using the Websphere datastageTX(Transfermation extender),I dont have the option to use the OUTROWNUM function here.
I am trying in this way,
F_Cnt(NUMBERTOTEXT(COUNT(EXTRACT(DebitAccNo Field:Transaction:Payment:PbtIn,DebitAccNo Field:Transaction:Payment:PbtIn="6548798277"))),INDEX($))
The number here i have asssigned is one of the account number(6548798277),
Insted of passing the account number i to want pass one variable(s),which contails all unique
account numbers but the loop is not working as i expected(as per my requirement).
I would appricieate if have any suggestions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: