Alteryx filter only until the first blank row

Question

Hi,

I have a spreadsheet which has rows, then there is a blank row and then it continues with further numbers; but I just need the data until the first blank row (the rows can increase but there will always be a blank row), and just ignore everything else below the blank row

This is what I have

IDCOUNTRYSALES1SPAIN

10002GERMANY20003GERMANY3000    SURPLUS56000

I just want to extract

IDCOUNTRYSALES1SPAIN

10002GERMANY20003GERMANY3000

Kind Regards,

Daniel

Felipe_Ribeir0 · Answer

Hi @DanielCarro

I am glad it helped. Please accept my answer as a solution, so the topic can be considered solved :)

Thanks!

DanielCarro · Answer

It worked Felipe, thank you very very much

Felipe_Ribeir0 · Answer

Hi @DanielCarro

Try this new version

Alteryx filter only until the first blank row.yxmd