Join for a beginner

Hi everybody,

new user on alteryx, I try to combine two data sets with a join tool. The problem is that after that, I have 2 ou 3 times records more.

I combine with one field because I have juste one field in common.

I post my workflow iff you have any suggestion.

Sorry my question is maybe very simple...

Thanks

WorkflowRB220120.yxmd

Data Investigation

Accepted answers

danespoors

The unique tool allows you to select for all of the unique CNK values so if a value appears once, it will appear and if it appears 1000 times, it will appear. It will select all of the unique CNK values no matter how many times they appear which is essentially what a group by tool would do but this way you don't lose the rest of your data.

I'd advise the unique tool as in SQL terminology, this is essentially running a SELECT DISTINCT and returning unique values.

Hope that helps,

Dane.

All comments

RolandSchubert

Hi @remibrun ,

I think, the problem is that in the file "PromoSaleItemsReport.csv" there are multiple rows with same CnkNr and ArtName (e.g. repeated by PromoDate). What happens is that each rows with CnkNr x from LDV2018clean.csv/LDV2019clean.csv is joined to all rows with the same CnkNr in file PromoSaleItemsReport. You could e.g. include additional fields in join (maybe DateSale and PromoDate??) or add a Unique tool to get only unique CnkNr/ArtName from PromoSaleItemsReport.csv. What do you think?

Best,

Roland

danespoors

Hi @remibrun

I would recommend creating a unique identifier to join on. Concatenate 2 or 3 columns together using a formula tool to generate one perfectly unique column and use this to join the data together.

Repeating columns is a sign of data duplication and unique IDs are the best way to eliminate them.

In your formula tool, add a new column and then it's as simple as [Column 1] + [Column 2] + [Column 3]

Hope that helps,

Dane.

remibrun

First thanks for you answer.

yes that's the problem. I have one data set with all of my sales lines (for one store) et I have one data set with more information for each CNK (unique identification of one product).

I would like to join the two data sets to have one big data file (with all the sales lines and the information cnk for each line). Normally I would have the same numbers of lines and more fields?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703