Is there are way to extract the date from the name of the dataset(excel file) and add it as a column of the table. I need to a trends analysis and I have the extracts in the form of excel and would like to create a repository.

[AbhrajitG]

The respository needs to have the extracts/snapshot on particular days (e.g. once a week on Monday) and create a repository i.e. differentiated on the basis of the date they were extracted. The date would be the name of the file.

Any suggestions?

[APrasad_Tri]

HI @Abhrajit Ghosh? , thank you for reaching out!

There are metadata references in Trifacta that you can use. In order to get the filename as the column in your current data structure, use filepath as shown below

After adding the column, you can expand the row to get the filename and date. Use the extract transformation to extract the date value as a separate column. Bring the cursor to the row value, drag the cursor and select Apr2010. Use the suggestions - Extract value matching.

There are many suggestions. The selection of the Trifacta pattern will give a generic selection and will pick all the dates in the dataset

The preview will help to pick the correct pattern for all values in the sample. Hope this helps. Please let us know if you have any questions.

Best,

Apeksha Prasad