How to delete a specifc row number in alteryx?

[user1850275]

Let's say I want to delete row 5? How do I do that?

[DataNath]

Hey @user1850275, you can add a Record ID tool that will assign an index to your data, then just Filter based on that. Find your example below. If you need to apply this to ranges etc then you can add and adjust a custom Filter expression as necessary.

[user1850275]

thank you DataNath! If you can help me merge the first row of my data with the header of my data this would be greatly appreciated !!!!!