Azure Data Factory - Lookup and If Condition Activities (Part 3)

In this video we review the lookup activity and If Condition activity along with some expression language within Azure Data Factory.

Azure Data Factory - Metadata Activity (Part 1)
Azure Data Factory - Stored Procedure Activity (Part 2)

[junaidmalik]

Hi Mitchell, i don't know of best way to tel you thank you. my manager 3 days back gave me a case(scenario) and asked me to explore ADF and work on the case., and after watching your videos i don't feel incomplete on any topic u have covered so far, and i have completed half the requirement iven by manager :). really thanks for the videos.

[alfredsfutterkiste]

Very informative. Very entertaining also. Natural teacher

[subhashkomy]

Excellent work sir. Appreciated your hard work and teaching us

[AnthonyJennings]

Great video, well organized, clear voice, and kept short. Thanks!

[AlphaGhost]

Great content Mitchell. Love your videos !!

[shockey]

Keep it up, Dear.
You are doing a great job :)

[JamesFLaPierreIII]

We appreciate you! Thank you very much for sharing.

[joshualee]

didnt know u could do a logical comparison of 2 dates like this .. i was under the impression that some sort of date conversion is required

[vijayanv]

Thanks for the video if the last file still in progress in the pipeline how we can set the condition could you please help

[vivekkacham]

Does ADF replace SSIS or does ADF has all the functionality as SSIS?

[dharmveerchaudhary]

Pls give any idea, how to kill infinite loop created inside the until activity in azure data factory

[michael_r_p]

Hi Mitchell i want to compre a value from a lookup resource from a XML file and try to put in the dynamic content this variable but it always give me the error of the ':' in the variable. there is a way to put a : inside the expression?

[naveenshindhe]

Hi, Can we execute insert SQL like below in Lookup activity.. please let me know.
insert into Table1 (Column1) Select ('test1');
select x;

[gerryviator]

Thanks for the video!!

What if I want to use a parameter value for adddays function like so...replace the 90 with parameter value?
@formatdatetime(
adddays(
converttimezone(
utcnow()
, 'UTC'
, 'Eastern Standard Time'
)
, -90
)
, 'yyyy-MM-dd hh:mm:ss'
)
Thanks much

update. Looks like I solved my own problem..
@formatdatetime(
adddays(
converttimezone(
utcnow()
, 'UTC'
, 'Eastern Standard Time'
)
, int(pipeline().parameters.P_DaysToGoBack) )
, 'yyyy-MM-dd hh:mm:ss'
)

[ObjectDesigner]

Hi content is super, I would recommend to not frequently zoom in / out, viewers can see everything w/o it, also I am not against your face but it hide sometimes content ;).