I would like some input on how to include adding File Name and File Date in import settings.
In typical Multiple File Import, we have
<<Set Add File Name Column( 1 ),
<<Set Add File Size Column( 0 ),
<<Set Add File Date Column( 1 ),
However, this will not work in my case. So I tried using New Column () function, but it gives empty columns or no column "Source File" at all.
For(i = 1, i <= N Items(selectedPaths), i++,
path = selectedPaths[i];
dt = Open(
path,
Headers(1),
Column Names Start(1),
Data Starts(2),
End Of Field(","),
Invisible
);
dt << New Column("Source File",
Character,
Set Values(Repeat(path, N Rows(dt)))
);
I guess it should be included amongst dt = Open () setting but I do not know what to put there for File Name and File Date Columns.