topic Re: Concatenation of all dynamic fields in Alteryx Designer Desktop Discussions

Concatenation of all dynamic fields

CaptainJaneway — Wed, 10 Apr 2019 09:17:25 GMT

Hello Alteryx-Community,

I want just to concatenate ALL fields from a "Optional Incoming Connection"-Input without GroupBy. Showing Field Map is not necessary. The number of fields and their names can vary. But the type and comma-seperator will be for all fields the same. The type of all fields is V_WString. First I tried it with "Select->All" in the Summarize-Tool. But it didn't save this configuration for other vary incoming connections. So i want to try update Raw XML, but I'm not familiar with it and my first try was with inspiration from another topic. Unfortunately it does not work. I appreciate any help!

Thanks and greetings

Re: Concatenation of all dynamic fields

afv2688 — Wed, 10 Apr 2019 10:05:01 GMT

Hi @CaptainJaneway,

I don't seem to get what you are really looking for, because what you are telling us and what I see on the image are different things.

What I suppose that you want to do is select on the list box the fields and concatenate them on the summarize tool. Am I right?

Like on this example, concatenating a name, address and a phone number:

Re: Concatenation of all dynamic fields

CaptainJaneway — Wed, 10 Apr 2019 10:44:40 GMT

Thanks for your reply. My english is unfortunately insufficient to express my wishes correctly. I added a sample of my Alteryx-Workflow. I don´t want to concatenate all field values, but all values by each field. My reason for all this is, that I want to create a delete sql statement. My only problem is that I can´t handle vary incoming connections.

Re: Concatenation of all dynamic fields

afv2688 — Wed, 10 Apr 2019 11:39:23 GMT

Hi @CaptainJaneway,

First, your english isn't bad, it's really good :) but to explain sometimes what you want to do is difficult even to your colleagues speaking natively (some experience in the field haha).

Second, I have seen you SQL statement and looks great. I haven't worked in a while with SQL statements but it seems that for my example and using your WF:

DELETE FROM tableDummy WHERE [address] IN ('fake street 123') AND [name] IN ('erick') AND [phone] IN ('555-568-789')

Shouldnt in the statement the column names be without the square brackets? Don't know it that is the issue.

Also append the the semicolon :)

Re: Concatenation of all dynamic fields

danilang — Wed, 10 Apr 2019 11:51:54 GMT

Hi @CaptainJaneway

You were very close in your original macro. All you needed to do was replace this part

With this

The summarize tool in your original doesn't handle dynamic fields. I replaced it with the transpose/crosstab/transpose sequence, all of which handle dynamic fields, and the sequence gives the same results as your 3 original tools

I made a couple of other minor changes as well. I had to increase some text field sizes and your Crew's macros aren't installed in the same location as mine, so I had to reinsert the Dynamic Metadata macro

Here are the results

The image is a little small but in the second one I renamed all the fields, deleted [Card] and added an extra one [Field8].

Fun debugging exercise

Dan

Re: Concatenation of all dynamic fields

CaptainJaneway — Wed, 10 Apr 2019 12:20:09 GMT

I bow to you!! That´s it! Now I can delete easily all occurring rows from my database. I also add the semicolon ;) Best regards