Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How can I join multiples column from multiple find and replace without a common column

AlanoudF
7 - Meteor

How can I join multiples column from multiple find and replace without a common column 

4 REPLIES 4
FrederikE
13 - Pulsar

Hey @AlanoudF,

 

I think you have to explane a bit further what you require and maybe share some (dummy) data. 

 

In general the only option to join without a common column to join on would be to join on the "record position".

FrederikE_0-1685968680107.png

 

Raj
16 - Nebula

please provide some sample data.
or elaborate the question

AlanoudF
7 - Meteor

I have multiple output column from different find and replace and I want to join them in one output ,so I can create a single formula to multiply them by each other.

SeanAdams
17 - Castor
17 - Castor

 Hey @AlanoudF ,

 

In general - there are 2 ways to join data together if you don't have a common column - the first is to use the append tool, which adds every row and column in set A to every row and column in set B.    The second is to use a join tool and join on position (it's an option on the top).

 

Other than that, your challenge is which rows should join to which rows.

 

In further helping you solve this particular problem - have a look at this post: Solved: Posting for fastest possible solution! - Alteryx Community

If you provide some example data; and examples of what you've tried and what you're stuck with - the community can often help you get there pretty quickly.    

 

Have a great weekend

Sean

Labels
Top Solution Authors