Concate strings from different Text Box tools to an existing field

[mathias_schnoor]

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

[Joe_Lipski]

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

[mathias_schnoor]

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]

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.

[mathias_schnoor]

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]

There's always a solution 

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

[mathias_schnoor]

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 · Accepted solution]

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.

[mathias_schnoor]

Hey Adam,

thanks!

That is the solution where I' am looking for.

Mathias