Alteryx filters the rows with an space in the beginning

[GOL]

Hello, 

I have an excel file with rows that are the sum of the rows that are below. For the example below the cell B2 is the sum of B3, the cell B4 is the sum(B5:B6), the cell B7 is the sum(B8:B9)

I have to delete the rows that contain the sum. This is, rows 2, 4 and 7.

I have tried to filter by the rows that start with a blank space, but Alteryx  deletes the blank spaces when it  loads the excel file.

There would be another option? 

For example, can Alteryx detect if there is a formula in a cell?

Thank you so much.

regards, 

[binuacs]

@GOL if your sum fields are ending with 1 then add a filter tool and write the condition

!EndsWith([Field],’1’)

[ShankerV]

Hi @GOL 

Based on your data, I see A1, B1 and C1 where 1 is common which you want to eliminate.

Filter the column with condition if does not contains "1"

!Contains([Field1],"1")

Many thanks

Shanker V

[GOL]

Oh, thank you so much but I think the example I've provided isn't appropriate.

There is no relation between the sum field and other rows, just the format in which they are written and Alteryx delete it when loads the excel.

Some other ideas? 

[binuacs]

@GOL The fields other than the sum fields start with a space?

[ShankerV]

Hi @GOL 

Can you please share the sample excel sheet.

Many thanks

Shanker V

[GOL]

Hello Binuacs, in excel the sum filelds don't star with space and these are the ones that I want to delete.

The other rows, in excel, start with an space and these are the ones that I want to keep.

Regars, 

[binuacs]

@GOL Then in the filter condition you can add StartsWith([Field],' ')

[GOL]

Hello, the solution does not work. It seems that Alteryx delete the space in the beginning when it reads the input file. 

Please find attached the mentioned file.

When you read it in excel the beginning space appears but when you open it with Alteryx the space disappears.

Please, any ideas?