Forum Discussion
Anonymous
4 years agoNot applicable
Power Query AI: FilterNullAndWhitespace
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....
v-yalanwu-msft
4 years agoCommunity Support
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.