Hi. I have one question. I have created a Azure data factory model based on one excel file related to one year. But even if different excel files loaded in to Azure data factory, the functionality inside stored procedures should calculate based on one particular year, For ex 2021 excel file, the functionality should be executed based on only 2021 excel file. How to do this in Azure data Factory.
Thnak You!
Too nice thnk u
Welcome 😁
Hi. I have one question. I have created a Azure data factory model based on one excel file related to one year. But even if different excel files loaded in to Azure data factory, the functionality inside stored procedures should calculate based on one particular year, For ex 2021 excel file, the functionality should be executed based on only 2021 excel file. How to do this in Azure data Factory.
Is there any we can reduce time of pipeline trigger time for small dataset also it is taking 3-4 mins?
Thankyou sir
Suppose i want to filter for particular empids,how to write the expression..
I have tried similar to equals it didnt work.
How to filter multiple values for single column or multiple column.
U may need to use conditional split in that case
I tried to filter but its does not show the ouptut
How to use like clause in filter transformation
There is a function called like in expression builder similar to equals, which can be used
how do i split for two different columns?
you need to use derived columns and in the expression builder use split