Forum

Add a column from t...
 
Notifications
Clear all

Add a column from the source files datas

2 Posts
2 Users
0 Reactions
92 Views
(@yeahremy)
Posts: 1
New Member
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

 

Capture2.JPGCapture3.JPGCapture1.JPG
 
Posted : 13/03/2021 10:50 am
(@mynda)
Posts: 4761
Member Admin
 

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
Share: