Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
12
Views
Topic starter
Hi all,
I need help adding something simple. a column.....
I need to combine 4 bank files (2 from the previous day and 2 for current day) to see if there were any movements.
When I launch my request I have all the datas that ares in my files but I would like to add some datas from the source files. For some reason i have the
file name already set up but I also need the modification date of the source file in column H (capture 3).
This date will allow me to do a formula to take balance from modification date 1 in another column and modification date 2 in a seperate one and
do the difference.
Unless you see a more simplier way to do thins the idea is to create the table then I create sheets with V searches to fill my tables.
The Modification date should be in front of the Source.name file line so that i can idnetify which balance is what.
So if date is day then take amount column H for example.
If anyone can help me with this thank you very much
Remy
Posted : 13/03/2021 10:50 am
Hi Remy,
Welcome to our forum! I don't recommend adding VLOOKUP formulas to the output table of a query. You can get the meta data from the file using Power Query.
When you Get Data > From File > From Folder the Date Modified and Date Created information is available for each file in the folder. Can you use that data for your needs?
Mynda
Posted : 14/03/2021 10:00 pm