This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 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.
You were very close in your original macro. All you needed to do was replace this part
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].