Convert files name in a folder to a column

Luong
Luong Registered Posts: 5 ✭✭✭

Hi community,

I have a specific use case where my data are stored in a Dataiku folder on S3 in separated CSV files everyday.

For instance, the extract date is only stored in the name of the files and not inside the files itself.

I want to use the 'Create a dataset' function to create a new dataset from this folder and I need the extract date as a column.

Is there any way during this process to create a column that stores the name of each source file from which I can extract the date with a Right 10 for example? I have not found such option in DSS:

Thanks a lot for your help,

Operating system used: Linux

Best Answer

Answers

Setup Info
    Tags
      Help me…