Forum Discussion
copy .csv data to warehouse
Hi Anonymous ,
I can also find the same result -
By default FileName and FilePath are designed like that.
As a workaround (assume file path won't change dynamically), you can use custom value -Hope this is helpful. Please let me know incase of further queries.
this is good. thanks
in source copy tab, I use
filename --> $$FILENAME which gives 'some-03-May-2024.csv' --> this is correct
directory_path --> $$FILEPATH but this gives the fullpath such as 'Data/some-new/some-03-May-2024.csv'
whereas I would like to see the directory such as 'Data/some-new'
thanks
Hi Anonymous ,
I can also find the same result -
By default FileName and FilePath are designed like that.
As a workaround (assume file path won't change dynamically), you can use custom value -
Hope this is helpful. Please let me know incase of further queries.
hi, I see you have hardcoded the value however my pipeline I would like it to be dynamic as the path will vary since the source varies
any suggestions?
thanks
Hi Anonymous ,
Can you please share the screenshot of Copy Activity - Source?
I would like to see how are defining file path dynamically? So that I can help you.
thank you
Hi Anonymous ,
Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.