I would like to get filename from below path using Visual expression builder in dataflow derived column in data factory.
/datafactory/raw/files/filename.csv
every row has got filepath. So filename is required in every row.
Asked
Active
Viewed 1,649 times
1 Answers
4
If the count of / is fixed in your filepath, such as /datafactory/raw/files/filename.csv, you can use this expression in Derived Column:split(filepath,'/')[5].Otherwise, you can try this expression:split(filepath,'/')[size(split(filepath,'/'))].
Data preview of Derived Column:
Steve Johnson
- 8,057
- 1
- 6
- 17
-
Steve - will split(filepath,'/')[-1] work too? – Apr 26 '21 at 08:59
-
1@azuresnowflake1 No, it doesn't work. It will give `NULL` result. – Steve Johnson Apr 26 '21 at 09:10
-
split(filepath,'/')[size(split(filepath,'/'))] - worked for me. thank you. – user2841795 Apr 26 '21 at 11:39