Hi All,
Good Day!!
We have a requirement to join multiple files which are available in ADLS folders which we have ingested from SQL Source and derive business logic accordingly. Since we store the Table data in ADLS with table name and date partitioned folder for incremental load from Source System. Now in order to read multiple files and join like SQL Query, initially I have to read date partitioned files in mapping data flow dynamically as per the current date.
ADLS folder structure: Tenant1/Raw/PolicyAdmin/SRC_ConceptOne/Entity/2021/07/09/

Can any give me idea how to read date partitioned files dynamically in ADF mapping data flow.
Thank you in anticipation!!
Regards,
Mahammad Khan

