Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
For challenges like this ( after working on challenge 33) I could always solve but in a messy way, and then I will read the solutions make by the others to improve my skills. Although each time I learnt something, but also find myself lack of the sense on finding the orderness of the data, the data in this challenge is based on position, and some others may have different rules.
( the data from challenge 28, Taxable_ A shares should be the sharetype,the data below should all in that type... also could be solved if use REGEX )
Or some Data Parsing problems, use Text to cols to separate one field to several columns, you will see so many info in one field with certain rules.
(the data from challenge 121 the text field with a lot of info...which could be split with the Text to cols tool )
I am willing to learn and improve my skills and these questions really helpful, although in my work I always get data from relational databases only which are much more cleaner ( at least in a better format). So I am curious about how can we get the data like this -- from which type of systems or tools or platform will run out the dirty data or could we solve it from that tool or update the tool ? Is it commonly used in our dailylife ?
