I'm trying to retrieve modification date of a file inside an archived file.
So first I put a tFileUnarchive component
Then I've tried to get the using native variable but I' ve not found the correct variable name :
Both don't work.
I've also tried a tFileProperties component to retrieve the mtime column (and also the mtime_string column)
But I dont' know how to put these values in a tMap component in order to write it in tFileOutputDelimited component (the goal is to create a csv file in output with the inside archive file modification time in it)
Any idea ?
Solved! Go to Solution.
Unfortunately it does not work
So here is my job :
- tFileProperties component with provided working input filepath
- tMap component with links between input columns (abs_path, dirname, basename, mode_string, size, mtime and mtime_string) and output columns (same names)
- tFileOutputDelimited component with provided working output filepath (all other properties are set with default values)
When I run the job, and output file is generated but it only contains semicolons (
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Practical steps to developing your data integration strategy.