Forum Discussion

arcegabriel's avatar
arcegabriel
Helper I
5 years ago

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.  ...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Hi @arcegabriel ,

 

As shown in the figure below, there is a incorrect field column in EXCEL2.CSV. The fields in excel1.xlsx are all correct, then when you combine files, select excel1.xlsx as the object template to combine.

1.png

4.png

 

Please see the introduction in the underlined section, select the object to be extracted from each file.

5.png

 

The result is as follows, the incorrect field is not extracted.

6.png

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.