Forum Discussion

tchristy99's avatar
tchristy99
Icon for Helper II rankHelper II
5 years ago

Splitting Query at null rows

I have excel files that are being dropped into a folder weekly. I am trying to use BI to pull them into a report, I don't have the ability to edit them before hand though. The stucture of these file ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Since you are working with a folder, I take it that at some point, you have a column of tables?  If so, let's say the table column name is "Data".  You can try:

 

FilteredNulls = Table.AddColumn(PriorStepName, "Filtered", each Table.SelectRows([Data], each [Column1] <> null))

 

Now the tables should each have been filtered to remove the nulls from each Column1 of your tables.

 

--Nate