Desktop productivity for business analysts and programmers

comparing files

Reply
Contributor
Posts: 41

comparing files

Simplist way in Enterprise Guide to keep and update all the rows in one file and add new rows and or update rows.

Example

 

Input 1

Tom Active

Bob Active

Tim Active

Jack Inactive

 

Input 2

Tom Inactive

Sue Active

 

Output desired:

Tom InActive (Updated row)

Bob Active

Tim Active

Jack Inactive

Sue Active (new row)

Super User
Posts: 5,378

Re: comparing files

What can be called simple depends on your preferences and skills.

 

By programming: data step merge, update or modify (or even SQL) will solve this "simple" update scenario.

 

If you are more of point-and-click-person, I think unfortunately the only standard component for this kind of of operation is Query Builder.

There you can do a full outer join. Remember that you need to define calculated columns using coalesce() function.

Ok, perhaps, not that very simple...?

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 241 views
  • 0 likes
  • 2 in conversation