hello hi everyone so in this video we are going to uh create our cool coin table then create our transform app and then load our data into our staging table then we're going to run our transform map put all the data into our core coin table and finally deactivate the transform app okay so let's go to [Music] us to studio click on create application file and then create a table so i'm going to give a name here core coin okay so i'm not going to have any module and i'm going to have a few fields the first thing let's say it's going to be id second field is going to be slug and i'm going to have coin i'm going to have you id i'm going to have symbol and i'm going to have website url i think that's all i need so they're all going to be string okay and um i'm gonna make one field here the display value i'm gonna put it to true here and then what else i need to do nothing else i'm gonna click on summit great so i have my uh cool coin tables created so let's now create our transform app so click on create application file type transform here and then you will see table transform app click on create so this is going to be coin details transform map okay the source table is going to be coin history the target table it's going to be cold coin okay and the order i'm going to leave it to 100 and click on submit so let's do some match all the fields i'm going to click on auto map matching fields so i have um pretty much all of them and i don't have here the coin field that's because i have you underscored coin sorry underscore name as code in my data source if i go back here you can see that i have the underscore name for the coin okay so i don't want to rename anything in my code i'm going to leave it as it is instead what i'm going to do i'm going to click on mapping assist and then look for name here and then map it to coin click on save and i should have now that field here you underscore name coin and here i'm gonna change the option here call ask i'm gonna set it to true okay so why i am doing this why i am setting that quads to true it's quite simple because we are going to load our data from our current history details data source which is actually going to load um around 11 000 more than 11 000 records okay so i need to make sure i don't want all the records i just need to have the coins all my eight coins so i'm going to use this option here koalas i'm going to set it to set it to true here so what it's going to do is going to see here i have one record for bitcoin and these are the other details and then it's going to have another card with the same name and it's not going to create a new record it's going to just update okay and in our case we can let it up update everything because if you see the data source what we are having as a result is only the symbol and id name uid website url so it's going to be always the same information okay so let's go and then load our data now okay so i have the completion code here success so let's click on run transform so i have the coin details transform app here this is my input set click on transform and it should process huge amount of record but we should have only eight inserts okay so we have four inserts now five six seven okay so transformation complete completion code success and let's go now to our coin table click on show list as you can see here we have all our coins all over eight coins okay we have the id slug symbol uid website url so now let's go to uh our transfer map coin details transform app we don't need it anymore all right so i'm gonna just deactivate and then save it great so thanks for watching see you in the next video