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 am brand new to Altreryx, so please forgive me if i am in the wrong place. I am trying to add a repeating column of data into a column. How would i align a column (A,B,C,D and make it repeat?) the First column would be unique values.
I like the approach that @Joe_Mako took in his solution. I liked it so much that I wanted to come up with an entirely different way of approaching the problem. Please see my "Invention" as an alternative way to get there. I first figure out how many times to repeat column B and then create a long column B to be at least as long as column A. Then I join the rows together and get to my solution.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Well, I started to try and out Goldberg @MarqueeCrew, but after banging together the BLOB CONVERT, SUPPORT VECTOR MACHINE and JSON BUILD tools I thought the better of it and grabbed a beer and sat down.
I did have an idea though so I'm adding this to reinforce the fact that there's always more than one way to do things in Alteryx. :-) (and I just used the SUMMARIZE concatenate recently)