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.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
I have one input set like
and i wanted to convert this into :
Appreciate your help
Thanks in advance !
Not sure how I would make this dynamic but here is one way of doing this:
A lot to explain here so if you have any questions or issues please ask :)HTH!Ira
Agree with what Ira said.
If you need it to be dynamic you can use the RegEx Tool, to identify the Capital letters within the rows and work with that.
number of row are dynamic how can we handle that ?
I have added one tag column like
can we play with that to get the desire output
@Ekmi9 Since you have added the Tag column so we can treat it as the "Group", which leads to a Batch Macro.
We can take the advance of the option of Data Schema Change option to allow the column to be unioned by name.Then a typical Transpose and Cross Tab operation to group the values together.
Thank you !
But I am not able to open this workflow. can you help me on this?
my Alteryx ver is 2020.2
@Ekmi9 Open with workflow in a notepad++ and change the version to 2020.2
I was playing around with your example to see if I can do it without a macro. I nearly got there with one exception:
The 3 numbers highlighted in the results: 17,19, 21 appears in row 2 rather than row 4.
I've added comments into every tool to explain what it does.
I'll have a think about how to resolve the highlighted issue.