The stuff thats removed - What was it?

Question
1

Hello!!! Glad the forum is back up and running. I use it all of the time as it continues to be a great resources.

There are many times I have a file with a list of employee names and a bunch of other data that comes along with that name. These come from clients. sometimes they have data errors and give us duplicate employee listings. When we try to import that into our system, our system says “nope!” What I do now is either de-doop or unique the data depending on the customer and their particular error.

As you know the converter is great about saying things like “65 records removed.” What I want to know is this. Is there a way to get an output of which 65 were removed??? Essentially we could report back to the customer their data errors so they could clean them up. I know with filters you could just filter one way and then do the inverse to see what the two outcomes are. how do you do this with de-doop or uniquing?

2

Was the forum down? I haven’t noticed any downtime.

We are just adding a new feature so that you can see what cells changed for transforms like Case, Date Format etc, where the number of rows and columns doesn’t change.

see-changes-w

But it is tricker to show rows or columns that have been removed.

However you can use Row Num and Subtract to create a dataset of all the rows that were removed.

image
image2478×1338 225 KB

Example:

diffs.transform (19.4 KB)

3

Ok, ill try that. Ya, there was one day for about 3 hours that when I put in the address it would not connect. no worries. like I said, amazing resource.

1 Like