Records Mismatch

Hi!

In my input file I have 144 records that need to be checked matched with a cost centre file. I've done a Join Tool to match the records between another. Afterwards, I did a Union Tool to combine the Left and Join Output Anchors but got more records. To trim down the data I used a Unique tool to revert to the original 144 records. However, I was only able to get 142 records. Two records dropped off. I'm not sure if i'm missing a step in my data preparation.

Requesting for some advise on this one. Thanks!

Workflow

Accepted answers

Ladarthure

Hi @aumali,

the unique removes duplicates based on a criteria, here if it is the ID, it means that you have 2 duplicated ID in yoiur dataset, if you however want to keep only these 144 lines, you could use a record_id tool just after reading your file and make the unique on this record ID!

if you want me to look at the subject deeper, could you please share the workflow?

All comments

Emil_Kos

Hi @aumali,

You have duplicated positions in your inputs. When you join the data you are creating duplicates.

Do your best to remove the duplicates before the join tool happens thanks to that you will make sure that the data quality is correct.

Good luck!

Ladarthure

Hi @aumali,

if you want me to look at the subject deeper, could you please share the workflow?

AngelosPachis

Hi @aumali ,

This is probably down to how you have set up your Unique tool. It's either that or you may have duplicates in your original file of 144 records. Do you mind using the same unique tool in your input to check if there are any duplicates there?

Regards,

Angelos

aumali

Hi Emil_Klos,

There are some lines with duplicate entries but I would need these to be checked since they need to charged to cost centre accordingly. Thanks!

aumali

Hi @Ladarthur,

That might be the case since I would need all the records to be checked in the input file once it is joined with the cost centre file.

Thanks!

Cost Centre Validation_eCommerce.yxmd

aumali

Hi @Ladarthur,

I did place in a Record ID after the input tool to give unique id's to each row. This was able to help out in the Unique ID Tool to get all the records.

Thanks again!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167