Query Editor

[Randy Haley]

I'm having an issue with trying to understand a PowerQuery that was sent to me to run. When I go into the Advanced Editor it looks like this:

I understand the 'D.FilePath.RevManualPY' is just the name box that points to the file path that the excel worksheet is located. "TB.Rev_Table" is the
last step in the 'Applied Steps' of the query. But what is "TB.Rev"? And where do I locate the function 'InputFile'??

 

[bbotzong]

Without seeing more, all I can do is guess... is Rev_Table a formal table? That is, if you click in it, do you get a contextual tab Table Tools? If so, then it is likely referring to a table object named Rev_Table...

 

[Randy Haley]

Thanks for your reply I'm not sure how the table was created since there are no hidden tables in the workbook. It appears that it some type of reference to ensure there are no duplicates. Below is another example where a 'table' object was created in the Power Query editor but I don't know how it was created or how to edit it. I'm trying to figure out how it works and then create it myself. The top image is from the Advanced Editor and the bottom is from the Query editor and you can see that its a 'table' based on the column 'Item'. The red arrow points to the line of M.

 

[bbotzong]

So do you have the source sheet? When you click in the table, is there a Contextual tab Table Design? When you click Data-->Get Data-->From File-->From Workbook, are there two sources in the Navigator tab?

 

[RoryA]

tblSourceData is the name of a table on sheet1 in the source workbook.

 

[bbotzong]

Are you seeing TWO data sources in the import process?

 

[Randy Haley]

You're correct in that its a 'Navigation' step in the Applied Steps routine. Below is how it looks before I add code for the file name and path.
The green arrow points to the creation of this new table but its NOT the name of the table in the source workbook sheet1. The red arrow
below points to the table name as Source_Data and the purple arrow confirms the box name as Source_Data. The Applied Steps pic confirms
its indeed the Navigation step. The last pic below of the Advanced Editor is how it looks once I've added the file name and path to the advanced
editor. And the last pic in the Applied Steps changes from Navigation to the name tblSourceData_Table. Then everything works great but I have
no idea how or why its included in the Applied Steps routine.

 

[Randy Haley]

Okay, it just dawned on me that the file name and file path are references to the original table! This is not my stuff and though I use Power Query I typically don't use references to other tables in other locations. The tblSourceData_Table is the name of the worksheet that is referenced in the file that I'm not physically using but is referenced in my file path and file name that I loaded in the Advanced Editor.