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.workflowrecords

[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).

[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 · Accepted solution]

Sample workflow

[danilang · Accepted solution]

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

[Ekta]

Thanks a lot :)