 Hey guys welcome to SSVD Tech social decide and today we are going to see about the set variable activity in the ADF. So in the last video we have seen about the lookup activity. So before going to see about the set variable activity I would strongly recommend to watch that video. I will provide the link of that video in the description of this video so you can watch from there because this is the continuation of that video. So what is the set variable activity? So set variable activity is used to set the value of an existing variable of type string bool or array defined in the data factory. So here we can set the variables under these three data types. So first is the string data type so we can set second is the bool data type so we can set for the bool and third for the array. So we can set for these three data types and here like we are getting the values from any another activity and that from that activity we are going to set the value into the variables by using the set variable activity. So go to the browser and we will see in the practical. So if you have remember in the last video we have used this lookup activity. So this lookup activity is getting the data for the refresh date. If we can go here and we will try to go setting and preview the data. So under the preview data we can see here we are having these columns but the refresh date we are more concerned on the refresh date. So here we can see the refresh date that is the fourth of April 2022. So we do not want to keep the values for other columns we are required to have the refresh date column value only. So how we can set the refresh date column value from this data set into a variable. So for that we have to use the set variable activity. So under the activity we can search for the set variable. So let me connect with this and let me rename this activity with set refresh date. Here we can see the variables but we did not created any variable yet. So first we can go on the pipeline level and here we can see the option for creating the variables. So let me quickly create the variable here and this is the last refresh date. So this is the variable that we have created and under the type as we can see we are having string type, Boolean type or array type. So I am happy with the string type and in the default value I am not going to pass anything. Go in the set variable activity and here we can see the variables. So under the names we can see the last refresh date. So this is the variable by which we are going to assign the values. So we can select this variable here we can see only one because we are having only one variable. So under the value we will be getting the value from this output of this lookup activity. So we can click on this add dynamic content and here we can see the activity outputs. So here is the get refresh date which is the lookup activity. Let me select this. Now here we can see the output of that. So we are only concerned with the first row of that output and which column so the column that is the refresh date. So we have to write the refresh date there and we can click on OK. So that is it. It will be going to get the input from this lookup activity and assigning the value into the variable that is the last refresh date by using the set variable activity. Now let me publish this and we will try to execute and we will be verifying the output of this set variable. So this will be having only a single variable that is the last refresh date and the value whatever the value is coming from the lookup activity. So publishing completed let me try to debug it. So we can click on this debug. So it will be executing as you can see it's running. So pipeline is completed. Now we can see the set refresh date which is this variable activity. So in this set variable we can check the output. So we can click on this here the output that we can see last refresh date the variable and whatever the value that we are having that you can see from here. In the next video we will be checking if this value that is the last refresh date value is more than the first date of current month. Then we will be going to load the data from one server to another server that we have already seen the requirement in the last video. So thank you so much for watching this video. If you really like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. See you in the next video.