Row creation based on input
Hi,
I am looking for an elegant solution in Aperture. The top part of the screenshot is example data. I need a way that if in column 6 or 8 the value is >0 then create a copy row with these values, set the original ones to 0 and in column 4 there will be a hard-coded new value "1003" for such cases. Does anyone have a suggestion how to do it? Please let me know if the example is unclear. Thanks!
Answers
-
Hi @Wojciech Glowacki if I understood you correctly, here is the solution that I think might work here.
Rather than copying rows, we can take the same row twice and apply different transformation to it.
- Take the source
- Add current row to preserve the sort order
- Split the records based on columns 6 or 9 having values greater than 0
- Those rows > 0, use the same output twice
- First to blank out the non zero values
- Second to hard code 1003 and increment the row number/id
- Union everything back together and sort by id
Let me know if this type of solution works for your dataset. I have attached the dmx for you to see.
1 -
Hi,
thank you so much @Jermolina, Katya I will check this out :)
1
