Help to combine data (solved)

Guys, I’m triyng to merge data coming from my existing database before importing into bubble.io but there are some rows that I would rather not include. Can’t find a way to filter those out.
Untitled

For item with variants, I would like to keep the rows of variants and filter out the first rows.
For item without variants, then I would just keep the first row.
Can anyone suggest a proper method? been all over these but still couldn’t figure out with my limited skills

Thanks heaps

Hi @yong! I would use the Row Filter step to accomplish this: https://parabola.io/transforms/row-filter

I would use two separate Row Filter steps to create two separate branches - one for when variants exist and another for when variants are blank.

Hope that makes sense. Let me know how that goes!