Page 1 of 1
reading 4 rows as one
Posted: Mon Jul 03, 2006 10:09 am
by thatiprashant
hi guys,
i am working with a credit card details,,i get the data in 4 rows, with one as amount, cardnumber, cv2 number and a filller record,,i need to read this as a single row so that it can show as single transaction,
help in this is very much appreciated..
thanks in anticipation
Posted: Mon Jul 03, 2006 10:29 am
by kcbland
If the rows are in a table, you're going to have to group and merge into a single row using SQL. Or, if it's in a file, you're going to have to use an Aggregation step to merge the rows.
Posted: Mon Jul 03, 2006 11:49 am
by thatiprashant
kcbland wrote:If the rows are in a table, you're going to have to group and merge into a single row using SQL. Or, if it's in a file, you're going to have to use an Aggregation step to merge the rows. ...
THANKS FOR UR reply...
Posted: Mon Jul 03, 2006 3:16 pm
by ray.wurlod
... or use a constraint such as Mod(@OUTROWNUM,4) = 0 on the output link of a Transformer stage, accumulating the four values in stage variables.
Posted: Tue Jul 04, 2006 2:57 am
by poonamgoyal
what exactly you want to say? i am not getting it. Can you please elaborate?
Posted: Tue Jul 04, 2006 8:11 am
by kumar_s
Do a Inverse Pivot based on the transaction id. Do a search on the to know available various methods.