examples of using Join by Record Position

[mstoler]

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

[ShankerV]

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!!!!

[ChrisTX · Accepted solution]

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