 Hey guys, welcome to SSUnitech, so we'll decide and today we are going to see about the append variable activity. So what is the append variable activity and where we can use that to use the append variable activity to add a value to an existing array variable defines in the data factory or snaps analytics pipeline. So for example, here we will be having a object type variable and that variable mainly contain the arrays and if we want to append the values on that variable. So for that we have to use the append variable activity. So for example, let's assume we are having a blob storage and under the blob storage we are having the files like we are having total six or seven files. So as per the requirement, we have one more variable and that is the array type variable. So we just want to keep the file names from the blob storage and adding in the array type variable with the comma separated values like the one, two, three, all these from there. And after that, we want to see those file names from that array. So this is the actual requirement. So go to the Azure blob storage and where we will see the files first. So we are under the SSU testing under the input container. And here we can see all these files. So we just want to keep the file names in a variable and how we can do that. So for that, go to the Azure data factory. And here before going to start, if you haven't watched the get metadata activity and funds activity, then I would strongly recommend to watch those videos because we are going to use the get metadata activity and for each activity in this video. So let me try to add a new pipeline and let me call this pipeline as append variable activity. Now here, first we need to use the get metadata activity. So under the get metadata activity, we need to go under this input folder. So here, go to the settings and under the data set, let me click on new. And this is the Azure blob storage. So let me click on the Azure blob storage. The file which is the delimited text. So click on continue. Here we can see the link service. So we have already created the link service, but here I am going to create a new one. So click on new, everything is there. Let me select the subscription. Then the storage account that is SSE testing and click on create. So that's it. Your link service will be created. And here we can see the file path. So we need to go here and under this input folder, let me click on OK. And here let me click on OK again. Now, so which property of the get metadata we need to use. So we can see the file list. Let me click on new. And in the argument we need to get the child items. So child items will be the file names which is available under this blob. Now, so if we can debug it, so it will be going to get all the child items from that input folder. So we can check the output of this. So here we can see the child items which is the name of the file, then the type. Then again we can see all those files there. Now let me close this. Now we need to use the for each activity. So for each activity we will be going to go through one by one with all these files. Now, before going to do anything in the for each activity, let me declare two variables. The first variable that is the file list and the type that should be the array type. Let me add one more variable. So this variable for the file name and this will be the string type. So that's it. Now we are going to use these two variables under the for each activity. Now here we can see the for each activity go to the settings and under the items. So we want to go through one by one on the child items of the get metadata activity. So we can see this one. So we can select and click on OK. Now here we can see the activities. So what we need to do under the for each activity. So first we want to use the append variable activity. So we can drag and drop the append variable activity here and go to the variable site. Here we can see the file list because we have declared two variables but in the dropdown we can see only one. Here it is fetching the variable which is the array type only. So that is the file list. In the values we need to get it from the output of the for each. So we can select that one and after that we can use the name from this item. Let me click on OK. So it will be adding one by one under this file list variable. Now let me try to debug it. So it will be executing. So here get metadata activities in progress. Now the append variable is executing. So here we can see the append variables so one two three and six times. So total six times append variable activity has been appended the variable. First it is the EMP.txt. In the second time it is adding item.txt and going forward it is adding one by one. How we can see all those in a single place. So go to the activity again. And after this append variable activity we have already seen the set variable activity. So let me use the set variable activity here and let me connect with this append variable. So in this set variable we want to set under the file name and the values. So these values should be coming from this file list. Let me click on OK. Now let me try to debug it again. So this time it will be going to execute and under the file name variable will be seeing all those. So here it got fade. So let me check the error. So it is saying the file name of the type string cannot be initiated the update of the array. So it is saying the variable which we have declared the file name which should be the array type that should not be the string type. So let me change it and debug it again. So it will be executing again and here we can check the output. So everything is executed. Here we can see the set variable. So here we can see all those values like EMP pay so total six files was in the source. So we can see all those six file here. So I hope guys you have clear understanding about the append variable. 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.