Forum Discussion
Detecting sources files with missing fields
Looking for some help from the experts I have a power query that pulls files on Sharepoint. It will pull out a particular table on them The tables are supposed to be the same but not always are. ...
Hi,
Thanks for trying this out. The question is that in your example. These two result on teh same:
1. If the column is missing in exce2.csv it will show in end result as "null" (what you did)
2. if the column exist but has no values in exce2.csv it will ALSO show in end result as "null"
My question was whether there is a way to different case #1 vs #2