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.
SOLVED

Adding two text input

Amy123
8 - Asteroid

Hi Team,

 

I have two text input . First one contain value 

 

Amy123_0-1624861633467.png

Amy123_1-1624861698226.png

 

and second text input contain 

Amy123_2-1624861739365.png

 

I need to have it together in a new column : Invoice Q1 is it possible?

 

Regards

 

 

5 REPLIES 5
KarolinaRoza
11 - Bolide

hi @Amy123 

yes, you can do it.

Use Union tool with: "Manually Configurate Fields" Option and adjust it as needed:

 

 

KarolinaRoza_1-1624869365140.png

 

Regards,

Karolina

Amy123
8 - Asteroid

Hi @KarolinaRoza 

 

No..the answer is not correct!

 

I need "Invoice Q1" in a column adding both values

Regards

Amy

KarolinaRoza
11 - Bolide

Hi @Amy123 

 

I am still now sure what you need.. 

Is it this?(attached)

 

If not can you provide more explanation.

 

Regards,

Karolina

Amy123
8 - Asteroid

@KarolinaRoza Yeaaaaee...:) 

Ben_H
11 - Bolide

Hi @Amy123 

 

Do you mean you want to create a column and have the value be "Q1 Invoice" or you want to create a new column titled "Q1 Invoice"?

 

If it's the first option you can simply append them together, then use a formula tool to create the combined value.

 

Ben_H_0-1624873072800.png

Ben_H_1-1624873091212.png

 

 

If you want to make that a column header you can use a dynamic rename tool..

 

Regards,

 

Ben

 

Labels
Top Solution Authors