ETL and Data Integration tools - Modern ETL software for everyone

Hello

I have a test file like this

Order|Product|Price|
....1|.....1|....10|
.....|.....2|....11|
.....|.....3|....12|
....2|.....1|....56|
.....|.....2|....10|
.....|.....3|....56|
.....|.....4|....89|

and I would like to create this one

Order|Product|Price|
....1|.....1|....10|
....1|.....2|....11|
....1|.....3|....12|
....2|.....1|....56|
....2|.....2|....10|
....2|.....3|....56|
....2|.....4|....89|

How can I do it?

Bill

Use keep value function

Mike

That did the trick

Never thought that it is going to be so simple

Bill