Discussions
-
Magic ETL - filling values in a column based on other values in the same column
Hi there, Ran into a bit of a roadblock with my MagicETL. I was able to get to a certain point using the Rank & Window function but I can't figure out how to do the next step I need. Below is an example of where I'm at after combining two tables and partitioning them based on ID and sorting them by date.…
-
Sum by using unique values in a different column
Hi there, I'm kinda stuck here, I've read other similar threads on this topic but I don't think any of the solutions applies to me because I'm using the global filters on the page quite a bit here. Below is an example data set Activity IDActivity CategoryEmployeeOrder IDOrder…
