Flag a field in input 1 if it exists in another field of input 2

[Newbie_1]

Hi!

I need  have 2 input files. I would want to flag in input file 1 if i find the time in input 1 in input 2 . Please help!

[cmcclellan · Accepted solution]

This should work:

Basically ... 

- create Input 1

- create Input 2

- join the inputs together based on the timestamp column

- those records that come out the L output should be assigned Flag = 0

- those records that come out the J output should be assigned Flag = 1

- union the 2 streams together.

It won't be in the order you reported, but if you want that then simply sort based on timestamp