Filtering with different criteria

[linwk]

Hi guys, 

I'm trying to take the data of all the countries including the "total" row. but when i filter the words that come before total, it also filters some other countries and I have no idea why. I have attached my workflow. It would be lovely if someone could help me 😞

Thank you in advance.

[JosephSerpis]

In filter 11 your syntax [Australian Petroleum Statistics] > "Afghanistan" you are applying a numeric filter with a string. If you wanted all the data for Afghanistan then you would want to use this syntax [Australian Petroleum Statistics] ="Afghanistan" 

[PhilipMannering]

Just use this in your first filter,

IsNull([Australian Petroleum Statistics]) OR
IsNull([Crude Oil & other])

P 

[jensroy · Accepted solution]

Well you are using a "Greater than" test in your filter.

You are asking to keep the records where "Field" > 'text value'.

I would do a few things differently. I would move date and "table source info" as column values.

I would use Sample tool to skip some blank rows.

Also you can use "dynamic rename" to promote first row to headers.

You can also "skip last x rows" with the sample tool to get rid of the last records you dont want.

Let me know if this works 🙂