 Hey guys, welcome to SSUnitech. So, see this side and this is continuation of PowerplayProjects. So, this is part 4 of PowerplayProjects. So, today we are going to record this video because one of my viewers has commented on my video and request to record video on this scenario. This is very important scenario inside the Powerplay. So, I am here to record this video. So, here we have two input tables. First is having T1 that is country and pending ARC. In the countries we are having India, Australia and many more. And inside the pending ARC, we can see the values like 20,000, 10,000, 5000 like this. In the T2 table, we are having two columns. First is country and second is opening ARC. So, these are our sources and what our expected output is. We want to get the values like this. Like first column will have the country, second will have the opening ARC, third column will be the pending ARC. And we will also have a slicer for the country. If the values of the country will be India inside the slicer, then we will get the output for India only. So, how we can design our Powerplay project? So, what about the Powerplay desktop and we will try to design it. So, here we are having data inside the Excel. So, we need to click on this Excel. Now, this is our source. So, we can select and click on open. Now, we need to wait few seconds. Here we can see here we have T1 and T2 tables. So, let me select T1 then T2. Now, click on load. Now, we need to wait few seconds. So, here we can see T1 and T2 tables have been loaded successfully inside the Powerplay. Let me select the table and here we want to get the data inside this table. So, we can drag it down and a little bit bigger from the right side and from the top as well. Now, we first column will be the country. So, let me try to drag and drop the country from T1 table. Then, go to on the pending ARC. So, the second column I guess, opening ARC that is available inside T2 table. So, let me drag and drop over here. Now, let me select the pending ARC that is our third column. So, here we can see we are having all these values but the data is same for all the pending ARC and opening ARC because here we are having the data as summarized. So, do not summarize it. Try to do not summarize it. So, here we can see we are getting this error because if we remove this then we will get the data because we have not create any relationship between T1 and T2 tables and we are expecting the data from T2 table. So, first go to on the relationship and try to create the relationship by using this country with the T1 and T2. Now, go back to the report view and try to drag and drop the opening ARC between the country and pending ARC. So, here let us check. So, do not summarize it. Now, we can see we are getting all these values but the country names are missing. We are getting only those country names which is all label on the T1 table because we are extracting the country from T1 table. So, this is our first problem like we are expecting all the countries if data is all label or not it does not matter. The second is we want to apply a slicer. So, let me select a slicer and make it smaller. Make it smaller from the right side. Try to drag and drop this country over here. So, here we can see we are having all these values. Let me try to make it drop down. Let me select go to on the format and go to on the items. I want to increase the font size. So, it should be 4. Now, we can select Australia. So, once we select Australia then we will get the data for Australia but here we are not able to see those countries which is available only table 2. For example, go to on the excel and let us see. So, this is our table 2 and here we have Afghanistan. So, Afghanistan is not available in the table 1. If we go on the country slicer so, we cannot see the Afghanistan over here. So, this is the second issue. So, how we can resolve these two issues? So, go to on the transform data and here I want to create one more table that will have only the country names from table 1 and table 2 both. So, we can use the append queries as new and here we can select the second table and we can click on ok. So, it will create one more table and let me quickly rename this table as country. After that we are not required to use these two columns. So, we can remove these. After that we are having all these values but here we can see we may have the duplicate values and here we can see one more thing like we have Australia areas in small letters and here areas in capital letters. So, we need to correct that one as well. So, go to on the transform data and try to replace that one and here we want to replace this areas with the capital one. Now, we can click on ok. Next thing we need to remove the duplicate values. So, go to on the home ribbon and go to on the remove rows. Here we can see option for remove duplicate. So, now we are having all the values. Now, we can click close and apply. It will take few seconds. So, we need to wait. Now, go to on the relationship view. In the relationship view it is automatically created this relationship. Let me try to delete that one and here let me delete this relationship and delete this relationship as well. So, as of now we do not have any relationship. Let me put in the middle between t1 and t2 table and try to make the relationship with the country table. So, drag and drop over here and here let me try to drag and drop with the t2. So, here we have done with the relationship. Now, move to report view and inside the report view you need to select this table. After that you can see we are getting the country from t1 table. So, we need to remove that one and now we need to get the country from country table. So, we can drag and drop the country inside the values and now here we will see we are having the Australia 1000 and 1000. The second chance we need to make in this slicer. So, the country it should come from country table. So, here just remove this and try to drag and drop the country from country table and now we can see as of now we have all. So, we can do the format of this table. So, go on the format and try to increase the size. So, go on the grid and just scroll down and here take size. So, let me increase that one. So, now we can see it is good. So, here we can see the Indonesia then other values. So, opening ARC is not available for Indonesia, West Indies and Australia. Now, if we want to do the sorting then we can click over here on the country and it will be automatically sorted. So, here we can see the opening ARC is not available for India, Pakistan and Sri Lanka and Jing Bombay. So, go to our excel and let's see. So, go to the final tab and here the opening ARC is not available for India, Sri Lanka, Pakistan and Jing Bombay. After that we can see the pending ARC is not available for Afghanistan, Indonesia and West Indies. Now, go to our power bank and we will see that one. So, here we can see Afghanistan, second Indonesia after that West Indies. So, we are having the same data as we want. Now, try to use this filter. So, let me select this Afghanistan. So, we will have that data only. Let me select the Australia. So, now we can see that data. If we will select the multiple values then we will have that one. I hope guys you have understand if you have such type of scenarios on your project then you can also use it. Some of introduced interviewers wants to know about such type of scenarios. If you have any another scenario then do comment on the video then I will try to record that video for you guys. Thank you so much guys for watching this video. If you 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 video. Thank you so much guys.