Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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