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.
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
one non-regex way is to use the Text to Column tool. The way to visualize the solution is that you currently have concatenated strings which also include “blank” values which are concatenated. So you want to “decompose” them, take out the blank values, and then only concatenate the remaining non-blank values. this can be done in 4 steps:
1) use a RecordID tool to enable you to recombine the parts without mixing up the original strings
2) use a TextToColumn tool, but choose out put to rows and with comma as the delimiter. After this step you will have many rows than before, each row contains either a blank or a desired string.
3) filter tool: to filter out the blank. Note: do experiment with isempty() and isnull() formula to see how their behaviours differ.
4) use the summarize tool to concatenate the “broken up” parts. Do remember to group by the RecordID field so that you get back the original string combinations minus the blanks.
i did not attach a workflow, hopefully the above schematics gives you enough pointers to reach the desired outcomes.
Thank you for your idea, however the example I have here is only a column in a dataset and filtering out the blank rows would make the other numeric columns to be incorrect so I think we cannot go with this option though.