Join Output Not Showing 8 Records

I imported 2 datasets and joined. Before joining, I implemented "record ID" tool on Precision_Mapping file (2587 rows) to join with "Field Number" on Precision_1 file (526 rows). The join output must only show "8" rows for FileName- ACH_CUSTOM because other files do not exist in Precision_1 file. For Precision_1, I configured Output file name as field as "File Name Only." Attached "joining workflow" output shows 510 records, however, there should be no more than 8 rows in final output. Attached is the final output in CSV.

joining workflow.yxmd

Alteryx mapping.csv

Datasets

Input

Tips and Tricks

Join

Accepted answers

alteryxuser_1184

I solved this problem using second key that is derived from "field label" in left table and "raw column name" in the right table. I removed record ID tool. The first key is "FileName" from left table and "raw table name" from right table.

All comments

Emmanuel_G

@alteryxuser_1184

It will be difficult to answer without having any input data.

Is it possible to share even a dummy sample of datasets ?

Kamran1991

for ease of understanding, please share dummy data for both input streams!

alteryxuser_1184

attached both files. Precision_1 has 18 files.

Precision_1.zip

Precision_Mapping.xlsx

Emmanuel_G

@alteryxuser_1184

I did a test and I think it is normal to have so many as rows in the join output anchor.

You're making a join on Field number for all files and master file precision mapping.

However, in the field number on the left side, there are many integers and duplicates of 1,2,3 and many others. So In the join ( all of these numbers will be filtered out seeing that inthe master file precision making, you have a recordID which begins at 1 and have values superior than 2000 ).

To my mind, the field mapping is not correct to have just ACH_CUSTOM in output anchor of join.

The origin of issue is ok for you ?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280