Problem in joining two tables

Ekta

Hi Frnds,

I have 2 input tables attached,

i want to join two tables so the value in second table finds the match in first table and append the data .

when i am doing this , my total number of records are increasing way too much in output .

input has 175 records and output has 6563 records .

Please let me know the right workflow

input and output are attached.workflow records records

Input for join 2.xlsx

input for join1.xlsx

output for join .xlsx

Developer Tools

Common Use Cases

Fuzzy Match

Dynamic Processing

Join

Accepted answers

ponraj

Sample workflow

Problem in joining two tables.PNG

Problem in joining two tables.yxmd

danilang

hi @Ekta

To change the version of the workflow

1. find the version of your version of Alteryx . go to Help->About and make note of the version number

2. open the .yxmd file in notepad and look for the yxmdVer node near the top

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2018.4">
  <Nodes>
    <Node ToolID="20">

3. change the version to match yours and save the file. just use the major revision number

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2018.3">
  <Nodes>
    <Node ToolID="20">

You should be able to open it now. It should run with no problems

In general, workflows are forward compatible, unless you use deprecated tools which may not be supported

Dan

All comments

JoeM

What you have is what we in the 'biz' call a multi-dimensional join. If Input 1 has 10 IDs that are 16164 and Input 2 has 20 IDs that are 16164, and you join them together, your computer is not quite sure what belongs where. As a result, each of your 10 identical IDs in inpur 1 will each be assigned the 20 records in input 2, resulting in 200 joined records! If you find your records growing in a join, look for this behavior.

What you should try doing is going to input data 2, make sure that instead of 20 idential IDs, they are all unique. Hence the unique tool in my solution! Check it out!

I also added afun trick join if your ever wanted to join by position which worked in this case as well (but probably won't in real life).

solution.yxzp

Ekta

Hi,

Thanks a lot for the workflow, but when i tried opening it .. this gave me an error saying need to upgrade the version as workflow is created on new version.

Is there any way to open the workflow without upgrade?

Also i have created multiple workflow in my current Alteryx, can they work on new version?

Thanks

ponraj

Sample workflow

Problem in joining two tables.PNG

Problem in joining two tables.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703