Hello,
I am new to Alteryx.
Can someone please give me an example of using Joing by Record Position?
This is something I have not worked with.
Thank You,
Michael
Solved! Go to Solution.
Hi @mstoler
Please find the example in Alteryx itself.
Right click on the Join tool and Select Open Example.
You will also have a sample dataset to check how it works and gives the output.
Hope this helps!!!!
I have used Join by Record Position when I'm sure I have only one record in both incoming data streams, to provide summary record count information.
Example:
Data stream 1: operations system: Use the Summarize or Count tool to count records
Data stream 2: financial system: Use the Summarize or Count tool to count records
Use Join by Record Position to arrange both of the counts above side-by-side, to output to a Summary Record Count sheet in Excel.
(as opposed to the Union tool which puts one value on top of the other)
Chris