okay everyone so in this video what we are going to learn or what we are going to do is basically taking the data that we have in our daily summary Tran data import staging table and transfer it into our to Covey 19 cases table so if we are going to create a transform map for that using that transform map we are going to do this operation okay so let's create our transform app so look for transform app here click on create and you will have this page here and I'm going to give a tail title clear name sorry daily summary data import transform map this is the name of my transform app here and then the sauce table is going to be daily summary data import table and there's a target awaits our coven 19 cases table so let's put the order to 200 because this is my second transform app click on summit ok and then click on auto map matching fields it's going to map automatically all the fields that I have in my source table to the fees that I have in my target table okay so let's look at the you understood date here this field and see the format it is not the same format that we have in our JSON response okay so we should work little bit with the format we should change the format there in order to have properly the date in our target table so this is the format that we should use so we should modify a little bit and then we are going to have properly our date inserted in the table so we have done with that and let's check one more time if it is ok great so now let's run the transform app I'm going to reload quickly the the form here and then click on transform okay so make sure that you have the right transform app selected here click on transform so we are running so we are transferring the data to our target table now it is done we have only fewer cards around 250 cards and for today and then click on one record here for example so you have the result for Afghanistan so this is basically we have done pretty much with the bring the data into our target table and we can check in the copy 19 table for example so we have the data for today okay so yeah so the next thing what we are going to do basically is how to automate this process how to take the data automatically from the response and then put it in this into into this table okay so we are going to create a schedule import thanks for watching