Union tool configuration

Question

Hello,

I was wondering if there was a way to configure the union tool to create a unique ID for each dataset attached to it. Therefore, if I want to identify specific records after the data has been unioned based on their original dataset, I would be able to.

SeanAdams · Answer

I'd also put record IDs (using a record ID tool) on each of the streams before hitting union - along with a dataset name (using a formula tool).

That's a very very common pattern, and an easy way to keep track!

@Dina idea of the filename on the input would eliminate the need for a dataset name.

Dina · Answer

If the data came from multiple Input Data tool, you can add file name into the dataset. Below is the configuration.

nagakavyasri · Answer

You can use RecordId after Union tool for unique identifier.

Union with unique.yxmd