Using the Power Query Add-In - Microsoft Business Intelligence Tools for Excel Analysts - page 148

12. Right-click any column header and select Insert Custom Column.
13. In the Insert Custom Column dialog box (see Figure 7-27), invoke the function and pass the
Folder Path and Name fields as parameters separated by a comma. Click OK.
Power Query triggers the function for each row in the data table. The function itself grabs the
data from each file and returns a table array. Figure 7-28 shows the newly created Custom
column with a returned table array for each file.
Figure 7-27: Use the Insert Custom Column dialog box to invoke the function.
Figure 7-28: Power Query triggers the function and returns a table array for each file in the directory.
14. Click the Custom column header to see a list of fields included in each table array (see
Figure 7-29). Select which fields in the table array to show, click the Expand radio button, and
then click OK.