Power Query AI: FilterNullAndWhitespace

[Anonymous]

Hi

I have a piece of M code that, I assume, was generated by AI.

In my Applied Steps it appears directly after the Navigation step.

Is someone out there able to explain what the 3 steps are doing.

The two steps afterwards, which I added, are both referring to the first step!  I've not seen this before.

FilterNullAndWhitespace = each List.Select(_, each _ <> null and (not (_ is text) or Text.Trim(_) <> ""))

Removed Bottom Rows = Table.RemoveLastN(Sheet1_sheet, each try           List.IsEmpty(List.Skip(FilterNullAndWhitespace(Record.FieldValues(_)), 1)) otherwise false)

Removed Bottom Rows = Table.RemoveLastN(Sheet1_sheet, each try     List.IsEmpty(List.Skip(FilterNullAndWhitespace(Record.FieldValues(_)), 1)) otherwise false)

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Anonymous ,

In my understanding, the first step is to convert the record to a list, determine whether the list is empty after skipping the first line, and then delete it.
Do you have all M codes to verify (sensitive information can be removed)?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Are these part of the function?

each before List.Select is creating doubt

List.Select filter the data 

Table.RemoveLastN rows

_ as the first parameter in List.Select seem like it is part of a function

[Anonymous]

Hi amitchandak

It does seem that the function is a precursor to determine which Rows to delete, but, I don't understand the syntax.

The two rows after the FilterNullAndWhitespace should have been:

#"Removed Bottom Rows" = Table.RemoveLastN(Sheet1_sheet, each try List.IsEmpty(List.Skip(FilterNullAndWhitespace(Record.FieldValues(_)), 1)) otherwise false),

#"Removed Top Rows" = Table.Skip(#"Removed Bottom Rows", each try List.IsEmpty(List.Skip(FilterNullAndWhitespace(Record.FieldValues(_)), 1)) otherwise false),