Data Output Duplicating

[Lkschwe]

I am combining two data sources and individuals are listed more than once on each data source resulting in the output duplicating several time.  Example: individual listed on one data source 14 times and another 24 times, resulting in output appearing 336 times (14 x 24).  How do I change my workflow so that the data only appears 14 times for the one date source column and 24 times for the other source column?

Also, please disregard my previous question sent on 6.10.2021.

Lori Schwengler

Below is a copy of my workflow:

[Luke_C]

Hi @Lkschwe 

Had to do a few things to get to the 17 records you expect:

1. Content data:
   1. Changed the date viewed to just date instead of datetime
   2. Removed duplicate records (mainly impacts the IWA Redirection records)
   3. Joined a lookup table for pathways
   4. Unioned back the 3 content courses with no pathway
2. Pathway data, joined to content on Name and Pathway
3. Unioned back records with no pathway