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.
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.