Ask Your Question
1

Replace value with another record value in same origin

asked 2018-04-24 04:17:23 -0500

Trans gravatar image

updated 2018-05-28 09:37:45 -0500

metadaddy gravatar image

Is there any way to replace one record value with another record value from same origin.

For Example, I have 2 rows with same same key as follow; where we need to replace put value with get value

Key;date;value
--------------------
1;24-Apr-2018;100;put
1;24-Apr-2018;200;get

Here I need output as below

Key;date;value
--------------------
1;24-Apr-2018;200
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-05-28 09:39:39 -0500

metadaddy gravatar image

You could do this in a script evaluator (choose from Groovy, JavaScript, Jython), but you would have to manage the case where these rows spanned a batch boundary. Also, how far apart could the two rows be?

In general, Data Collector is best at operations that are confined to a single record.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-04-24 04:17:23 -0500

Seen: 32 times

Last updated: May 28