Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Concate strings from different Text Box tools to an existing field

mathias_schnoor
11 - Bolide

Hi!

 

I want to concate strings from a existing Text Input tool and a lot of Text Box tools by running my workflow as an app.

 

Like:

[Field1] := [Field1]+"mytextboxOneText",

[Field1] := [Field1]+"mytextboxTwoText",

...

 

So my target become for example a correct url string.

Then I want to commit url string to an download tool...

 

I have try to reach this deployment with a Formula tool. Without any success.

 

It is possible to procurable this working order with Alterxy?

But how?

 

Mathias

 

 

8 REPLIES 8
Joe_Lipski
13 - Pulsar
13 - Pulsar

Hi @mathias_schnoor,

 

I've attached an example workflow of what I think you need, it will only work if you are running as an app rather than a workflow. If this isn't what you're after, could you attach an example of the workflow and an example of the output you are looking for and I'll have another crack?

 

Thanks,

Joe

Joe Lipski
mathias_schnoor
11 - Bolide

Hey Joe!

 

Thank you for your support, but want to work with n Textbox tolls back-to-back.

Do

you know a solution too?

 

Like:

[URL] := [URL]+"xy",

[URL] := [URL]+"xz"

 

Mathias

Joe_Lipski
13 - Pulsar
13 - Pulsar

Hi,

 

I'm not sure exactly what you mean... Could you possible post an example of the workflow you've build already if this would help.

Joe Lipski
mathias_schnoor
11 - Bolide

Hi!

 

I have post you an example, but is not how I try for!

 

Use une one new field not four new fiels where perfect.

 

Do you have any solutuion?

 

Mathias

Joe_Lipski
13 - Pulsar
13 - Pulsar

There's always a solution Smiley Wink

 

I think you may be missing Actions... Is this what you are after:

 

Capture.JPG

Joe Lipski
mathias_schnoor
11 - Bolide

Hey Joe,

 

thank you for your support.

You can attach a string  are executed in combination with variable call.
I didn't know this.

I think you have to concate always the strings like

"housenumber" + ",".

 

That what I mean and so the best solution for me are:

 

Result := [Field 1]+"housenumber"

Result := [Resut]+ "street"

Result := [Resut]+ "city"

Result := [Resut]+ "country"

 

So the result *.xydb has two instead of four column,

 

But it is not possible in Alteryx, I'm right?

 

So it is the only solutionfor for my question you have given me.

 

Best regards

Mathias

AdamR_AYX
Alteryx Alumni (Retired)

Hey Mathias,

 

I think what you might be missing is that actions can have multiple inputs (See the attached).

 

Then you can just build your URL in a sinlge formula in the action, and inject directly into a text input which the download tool can use.

Adam Riley
https://www.linkedin.com/in/adriley/
mathias_schnoor
11 - Bolide

Hey Adam,

 

thanks!

That is the solution where I' am looking for.

 

Mathias

Labels