Concatenation of all dynamic fields

Hello Alteryx-Community, 2019-04-10 10_45_58-Alteryx Designer x64 - DBtoDB.CT.MultipleSummarize.yxmc_.png

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

Transformation

Accepted answers

danilang

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

Concat.yxzp

All comments

afv2688

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:

CaptainJaneway

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.

DeleteStatement.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703