We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

combine fields from multiple inputs and create a separate table

hemant86
11 - Bolide

Hi All,

I have a below requirement. I'm having multiple fields coming from different inputs. I need to combine these fields to create one separate table.

 

INPUT 1-

Date
May 1st 2023

 

INPUT 2-

ATP Successful Transactions (Count)
29

 

INPUT 3- 

ATP Successful transactions (Amount)
 ₹                    953.40

 

Expected Output - in one table after combining 

DateATP Successful Transactions (Count)ATP Successful transactions (Amount)
May 1st 202329

 ₹                        953.40

 

Thanks in advance.

3 REPLIES 3
ShankerV
17 - Castor

Hi @hemant86 

 

Please use the join multiple tool.

 

Note: Use join by record position

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @hemant86 

 

One way of doing this.

 

ShankerV_0-1683733556540.png

 

Step 1: Input

 

ShankerV_0-1683733611153.png

 

 

Step 2: 

ShankerV_1-1683733636597.pngShankerV_2-1683733672354.png

 

 

Many thanks

Shanker V

hemant86
11 - Bolide

Thanks @ShankerV I was using the Multi Join but was getting lot of null rows. Checking the option Join by record position fixed it. Thanks again

Labels
Top Solution Authors