 Hello, welcome back. Today we are going to see about the Exist Transformation in azio data factory. What is the Exist Transformation and where we can use that? Here we can understand about the Exist Transformation. The Exist Transformation is the row filtering transformation that checks whether your data exists in another source or stream. The output stream includes all rows from the left stream that either exists or does not exist in the right stream. This is very similar to the Exist Transformation in the CQS over with the where exist and where not exist clause. This is a very straightforward transformation. If it is not clear, go to the azio data factory and we will try to see in the practical. Here our requirement is we can see inside the azio browse tables we have these two files. First is the employee file and second is the payroll file. In the employee file it is having the data for the employee ID 1, 2, 3 and 4 that we can see. Similarly if we can go in the payroll file it is having the data for ID 1, 2, 3 and 5. It does not have the data for the ID 4. Employee file we are treating as a source file. We just want to check whether the data is available in the payroll file or not. We can check by using the Exist Transformation. Go to the azio data factory. Let me try to add a new data flow here. Here first let me try to add the source. This source should be your employee source. Now go to the second source and this source is payroll source. As we have already created these two data sets in the earlier of these videos if you are following all these videos then you have seen those. Here we can click on this plus symbol and we can see the option for the exist. We can click on the exist. So in the exist here we can see like exist1 is the output stream name. We can call this exist only and the left stream which is the source 1 then the right stream which is the source 2 for the payroll 1. Here the exist type. Either we want to check the common data or does not have the exist. So we can use any one of these. So let me cover one by one. So first I want to check the common data between these two sources. Here we can see the custom expression. So under the custom expression we can see here we need to write the expression. We can open the expression builder. So under the expression builder we can select like we want to match with the source ID 1 and source ID source 2 employee ID. So this is we want to match either we can write it from here or we can directly select that by unchecking this we can select the column names here like the employee ID from the source 1 and employee ID from the source 2. So either way we can do that. Here we can go in the data preview and try to refresh it. So this time it will be having ID 1, 2 and 3 because only these three IDs are matching source 1 and source 2. So as we can see ID 1, 2 and 3 because in the source 1 ID 3 is coming two times. So this is the exist. In the same fashion we can go and try to select the does not exist. Go to the data preview and try to refresh it. So once we refresh it. So this time it will have only ID 4 because ID 4 is not available in the source 2. Now if you want to load this in the destination then we can add the sync here and we can add this in the destination site. So this is all about the exist transformation. If you have any doubt then you can comment your questions in the comment box. I will try to respond there. Thank you so much for watching this video. See you in the next video.