How can we automatically delete rows if there is no data in a specific column?

Hi,

Can anyone tell me how can we delete rows range in which if a specific column has no data in any of the rows, then it will automatically remove those specific rows?

For Eg:- In the attached file, how can I make the Alteryx workflow in such a way that if the Column O, if there is no data from row 2 to row 29, then it will automatically delete the rows and if there is data in row ranging from 30 to 40, then it will move the row 30 to row 2 and the data follows in subsequent rows and in case there is no data in row ranging from 30 to 40 in column O, then the same also should be removed.

Ep Test.xlsx

Dynamic Processing

Accepted answers

binu_acs

@Kartik21 you can filter out the value in Alteryx using the filter tool

NOT IsEmpty([Amount in Document Currency]) OR [Loop ID] != 'D'

All comments

binu_acs

@Kartik21 you can filter out the value in Alteryx using the filter tool

NOT IsEmpty([Amount in Document Currency]) OR [Loop ID] != 'D'

OTrieger

@Kartik21
Filter tool should work here

sanjeevmansotra

Hello everyone I introduce myself as Sanjeev Mansotra. In an Alteryx workflow, you can automatically delete rows with missing data in a specific column by using the Filter Tool. Set the filter condition to check if the specific column is not null (e.g., ![ColumnName]), which will keep only rows with data in that column, filtering out rows with empty values.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703