reading 4 rows as one

thatiprashant · Post by **thatiprashant** » Mon Jul 03, 2006 10:09 am

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

kcbland · Post by **kcbland** » Mon Jul 03, 2006 10:29 am

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.

thatiprashant · Post by **thatiprashant** » Mon Jul 03, 2006 11:49 am

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...

ray.wurlod · Post by **ray.wurlod** » Mon Jul 03, 2006 3:16 pm

... 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.

poonamgoyal · Post by **poonamgoyal** » Tue Jul 04, 2006 2:57 am

what exactly you want to say? i am not getting it. Can you please elaborate?

kumar_s · Post by **kumar_s** » Tue Jul 04, 2006 8:11 am

Do a Inverse Pivot based on the transaction id. Do a search on the to know available various methods.