Forum Discussion
Create a date custom column by file date
Hi everyone, I daily download a .csv file that has no date reference. I'd like to create a custom column that sets the date by the 'file modified date' (or similar). any ideas? Thanks!
Instead of combining binaries, add a custom column with formula =Csv.Document([Content]).
This will give you a table with the file contents, which can be expanded without losing the "date modified".
The "Content" column can be removed after you added the custom column.
Instead of combining binaries, add a custom column with formula =Csv.Document([Content]).
This will give you a table with the file contents, which can be expanded without losing the "date modified".
The "Content" column can be removed after you added the custom column.
MarcelBeug, good tip.
My new column is containing all of the info. I mean, it does not split into columns. Any ideas how to overcome this?
My file contains Tab separated info
Thanks