Data flow visual expression builder how to create date hierarchy path

Question

Data flow visual expression builder how to create date hierarchy path

sachin gupta 376

In Azure Data Flow, I am trying to build an expression for Source from where I will get the file. The source path is a blob container in Azure Data Lake which is given below:

GA/2021/09/16/abc/abcset1.csv

The date hierarchy which is given above gets created dynamically for the date on which the pipeline executes.

I am not able to create this directory path in the Data Flow visual expression builder wildpath source option. Can someone please help me to know how this path can be created?

Thanks

HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator

2021-09-23T20:58:44.527+00:00

Hello @sachin gupta ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator

2021-09-29T16:52:20.57+00:00

Hello @sachin gupta ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

Answer accepted by question author

0 additional answers

Your answer

HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator

2021-09-23T20:58:44.527+00:00

Hello @sachin gupta ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator

2021-09-29T16:52:20.57+00:00

Hello @sachin gupta ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

Answer 1

HimanshuSinha 19,637 Microsoft Employee Moderator

Hello @sachin gupta ,

Thanks for the ask and using Microsoft Q&A platform . The below expression should help .

@markus.bohland@hotmail.de (formatDateTime(pipeline().TriggerTime,'yyyy'),'/',formatDateTime(pipeline().TriggerTime,'MM'),'/',formatDateTime(pipeline().TriggerTime,'dd'),'/abc').

Please do let me know how it goes .
Thanks
Himanshu

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of [Q&A Volunteer Moderators][50]

sachin gupta 376 Reputation points

2021-09-29T18:51:06.74+00:00

@HimanshuSinha ... thanks for following up. I actually could not use that expression as I changed the entire logic based on the change in requirement. Though, we did use the similar expression in pipeline dynamic expression and it worked. Thanks a lot.

Share via

Data flow visual expression builder how to create date hierarchy path

0 additional answers

Your answer