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.
Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Thanks for your response. I have 14 millions rows of data coming from different inputs. So is kind of hard to put in a single example. All I want is to break down the changes on [ENERGY] column and [SLCHG] column of TABLE # 1 to look like
TABLE # 2
EXPECTED RESULTS TABLE # 2
The scenario is: IF [TYPSRV] = "E" THEN the [CHG AMT] is accumulated in [ENERGY]
IF [TYPSRV] = "L" THEN the [CHG AMT] is accumulated in [SLCHG].
It would be great to see a set of data (via a text input tool) that has only a focused set of data elements to work from. Then the expected or desired results. Looking at the pictures, I'm guessing at the source data. If you could make this look like a "Weekly Challenge", I'm certain that many folks could contribute help.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.