How should I change my calculation in the Filter Rows Tile in ETL?

giannzi
giannzi Member
in Magic ETL

Hi,

I am using the Filter Row Tile in the Magic ETL. I want to filter the Overall Credits Column and only get the maximum for each student. However, the MAX and FIXED BY don't work. How should I fix this? I also tried the Add Formula Tile and it did not work either.

MAX(Overall Credits)FIXED(BY Student ID)

Tagged:

Answers

  • ggenovese
    ggenovese Coach

    In Magic ETL you can use a Rank and Window Tile with a ROW_NUMBER function, sort on Overall Credits descending and partition by Student ID then add a filter tile for ROW_NUMBER = 1

  • giannzi
    giannzi Member

    @ggenovese Thank you for your solution. I tried doing it but when I add the Filter tile, it says that my source is not valid. Do you know how can I fix this? Thank you!

    image.png

    image.png
  • giannzi
    giannzi Member

    @ggenovese Oh nevermind! I found my mistake. I didn't add the ROW_NUMBER function. It's now good! THANK YOU!

Categories