Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power Query -- add column to table will file modified data to Column for all rows

Good afternoon, I would like to be able to add the file modified data to a column for all rows of an appended query. I have built two queries that produce the output shown below in two tables/tabs. The 2nd query does basically the following: • Looks at files in published pricing folder for the current period Filters for *.xls files (to remove the PDF versions) • Filters for “Approved Pricing” file that are "published" there • Removes 6 top rows and promotes the 7th row as “header” (data/file cleaning) • Renames some of the columns names to be more identifiable • Appends all those files (several hundred files and thousands of rows into ONE table) The fist query/table just shows the file information, shown in (table 1). I need to modify the 2nd output/query to add a column that has the date modified from the originating file for each associated row in (table 2). I need this info for two reason: one for historical price changes, and 2nd because I will be working different project that will update the "billing: system" with the latest price. I am sure this step is likely quite simply, I just didn't know where or how to add that step in the 2nd query.

 

Thank you in advance., Kevin

(Table 2)

2 Replies