Hi, I'm Zor. Welcome to Unizor Education. We will continue talking about electromagnetic induction, but in this case about some construction which is much more practical than the one which we were using in the previous lecture to generate electricity. Now, this lecture is part of the course called Physics for Teens, presented on Unizor.com. I do suggest you to watch the lecture from the website. You have to go to Physics for Teens course from the main page of the site and then choose the electromagnetism under the Physics for Teens and choose the electromagnetic induction topic on the next screen. The whole thing in electromagnetic induction is based on the Lorentz force. Let me just remind you a couple of things which we were talking about in the previous lectures, but I think it's very important to understand the fundamentals of this because everything else can be logically derived from this one fundamental fact. So the fundamental fact I'm talking about is if you have a magnetic field which is directed perpendicular to the board towards, behind the board, so we are looking at the end of the magnetic field lines. So these are magnetic field lines which go inside the board. And there is a charged particle. Let's use the electron in this case. So this is an electron, minus. So it goes this way. Now, as soon as it goes into the space where this particular kind we are considering uniform magnetic field is, it deviates from the trajectory this way. This is the manifestation of the Lorentz force. Now everything else, as I was saying, just follows from this. Now next experiment was with the rod. So instead of this, consider we have a rod, metal rod, which is moving the same this way. What happens in this particular case? Well, in metals, atoms are more or less stable at their position because of interatomic forces, links, whatever. Electrons are rotating on certain orbits around nuclei in each atom. Now there are so-called free electrons, like one or two electrons from the outermost orbit around each atom. They're relatively free, which means they can jump from one atom to another. They're relatively far from the nucleus, so the connection between the positive nucleus and the negative electron is a little weaker. And then electrons are basically very active particles and they can jump from one atom to another, basically acting like free agents. The whole body of the metal remains electrically neutral, but there is some kind of a movement of electrons in between. So these free electrons are very easy to basically bump from wherever they are if there is some kind of a force. Now, as this particular rod is moving across the magnetic field lines, it pulls all the free electrons, right? So each electron, each free electron inside this rod is pulled towards this trajectory. Now, you remember what happened with electron if it moves this way. There is a force, Lorentz force, which moves it vertically down on this picture, right? Which means that these electrons will be forced towards the bottom of this rod. So as the rod moves, and that's very important, it's moving, so electrons are moving. And as they are moving, there is a force which pushes them down, so each electron has this orbit. So these electrons are connecting, are gathering at the bottom of this rod. Now, are all of them gathering there? No, obviously not, because they are repelling each other. So there is certain density, if you wish, of the free electrons, which are accumulated on this end, and therefore there is a lack of electrons on the opposite side, and that what makes the voltage between these two points. Now, the electrons, as I was saying, are repelling each other. So if we are moving slowly, the Lorentz force is not as strong, which pushes the electrons down. So the density of the electrons is not as big, so the voltage is not as big. But the faster we are moving the rod this direction, the stronger Lorentz force pushes the electrons down, and that's why they are more dense, and their difference in potential between top and bottom is greater, so there is a greater voltage. Okay, so we understand that. Now, if you are moving with a certain constant speed, well, there is certain density of the electrons which can be accumulated at the bottom part of this rod, and there is certain fixed voltage. It will not go any further because repelling force from the electrons is neutralized by the Lorentz force which pushes them down. And there is this dynamic equilibrium, there is this maximum density at this particular speed of the rod. Great. Now, what happens if we are connecting in a circuit? Well, there is a difference in potential here, right? So electrons are here, minus. This is positive. So what happens? Well, obviously there is an electric current in this case. Current goes from plus to minus, so current goes this way, and certain number of atoms or absence, yes, atoms with absent electrons are supposed to move this direction. Now, what does it actually mean that the positive is moving here? It basically means that the free electrons from here will replace these guys, which seems like they are moving basically, electrons are here and lack of electrons is moving here. So gradually lack of electrons is reaching this point and the electrons which are accumulated here will replace those holes which are here, which means there is less density and the Lorentz force is constant, right? These are rails. You remember you taught me about the experiment. So Lorentz force is constant, density is less, so certain new electrons are pushed by the Lorentz force down to basically replace whatever has been lost here. So electrons goes this way, the electric current goes opposite direction, and so we do have a loop which is the electricity between this electric current generated by moving the rod is constant with a constant speed. Now, as far as the formulas are concerned, now if you remember the Lorentz force, if there is one particular particle goes this way, it's Q times V times vector product B. So if Q is negative, then the whole thing becomes negative. Q is positive, it's positive, so that's why it's vector quality. Okay, so this is the Lorentz force on the charge Q. We know that from this we have derived another formula in this particular case. We have derived the formula that the... Well, if you consider I to be the current in this particular case and U to be the voltage between these things, which is maintained constant, then the I times U is the power, if you remember, power of the current running, and the work during some time dt would be this. That's the work which is performed by this. Now, at the same time, we are moving our rod with the constant speed to the right. Now, what happens in this case? Since we have a current, we have another manifestation of the Lorentz force. Remember that if there is a current running in the rod, then the rod itself is pushed in one particular direction. So if this rod is moving this way, the current moving this way, and this is basically exactly the same thing. When the charge is moving in the field, there is a force which moves it towards a direction which is perpendicular to its speed and the magnetic field lines. Same as in the beginning, each electron as it moves here is pushed down. Now, since we have this current, we have electrons are moving this direction, right? And if electrons are moving this direction, so it's a combination. Electrons on one hand are moving this way because the rod pushes them. On another hand, electrons are pushed down the road because the Lorentz force. But as they are pushed down the road, there is another magnetic effect of Lorentz force in the magnetic field. As they are going down, then there is a force which is supposed to be perpendicular to this, which is their movement, and direction of the magnetic field lines, which is this. So we are moving to the right with a constant speed by overcoming another manifestation of the Lorentz force. So Lorentz force moves our electrons down, but at the same time this causes another Lorentz force to move against our rod. And to move it with a constant speed, we have to really spend a certain amount of work to overcome this force, right? The same force. Okay, so to overcome this force, we have to move it with a certain constant speed, and the force, therefore, is constant. So if we will multiply this by the length of the trajectory of the rod, we will get also work. So this is a work by electric current, which is performed. Let's say it's converted into heat here in a resistor. On another hand, we have to exhort exactly the same thing, the same amount of work to move it with a constant speed to the right. Well, the s is obviously speed times time, right? Now, the force which is acting on the current is equal to, as we know, current times L times B, right? That's something which we have covered in one of the previous lectures. So if there is a rod with a current I, it has lengths L, and the B is magnetic field, this is the force which is acting on this piece of wire, this metal rod or whatever. From which we see this is cancelled out, and we have is equal to L times B times B, which is equal to, what is V? Well, if this line is, let's say, B and this is L, right? Now, V is actually V is equal to dB for dt, right? Because B is lengthening, because we are moving the rod, B is lengthening, and its derivative is the speed, right? And so we have equals to L times dB by dt times B. Now, what is this? This is, this is dB. This is the error, so L times dB is this error. It's increment of the differential of the increment of the error, and so we can say that this is dA by dt. This is increment of error times B. Well, B is a constant, right? A times B is called flux, magnetic flux, and that's what we have ended actually, the previous lecture. So this is equal to d phi for dt. Well, usually they put minus sign here because it's directed against the movement. But as far as the absolute layer of the scalar is, the derivative of the flux is equal to voltage or electromotive force. Now, this is something which is a repetition, basically, of whatever was before, and I was trying to come up with something which is more practical as far as generating the electricity. Because to generate the electricity using the moving rod is kind of technically difficult. How long can you move it, right? There is a better way, and that's what we will very briefly talk about right now. So what's important here is the very last formula that the EMF or voltage is equal to minus d phi by dt, a change of magnetic flux which goes through this frame. You have this frame, and you have magnetic field lines going through it, and as we are increasing this distance, the flux is increasing. So we can do exactly the same type of logical manipulations to find out the following. If you have magnetic field lines, let's put them this way, and the frame, the wire frame, rotating along the vertical axis on this particular drawing. What happens? These two lines are always crossing the magnetic field lines. So because they are crossing, it's exactly the same as before we had this picture, and we had the rod which moves this way across. So magnetic field lines this way, rod goes this way, and that's why there is a generated electricity. Same thing here, just a different view. Magnetic field lines this way, but from this position if we start rotating, so this rod goes behind the board, and this rod goes in front of the board. So they are moving this way, which means they are actually crossing the magnetic field lines. They are crossing the magnetic field lines, which means there must be electricity generated in this particular rod and in this particular rod. Because of the same consideration we were using before, we were talking about Lorentz force, et cetera. Electrons are pushing this way, that's why Lorentz force pushes the electrons vertically, down or up depending on the direction of rotation. So this is the rotation, and that's why there is an electric current. What's important is that this part of the wire loop is going into one direction. This one goes to another direction, which means that electricity should be generated, electric current should be generated in opposite directions. So let's consider this one goes this way, then this one will be this way, which means we have a loop. Now, if we don't have any connection here, then what happens is basically the certain amount of electrons will be generated and stop generated, because they will repel each other, as this thing moves this way and this thing moves this way. What happens if we will continue the rotation? Well, if before this particular thing moves towards us, that's one direction of crossing magnetic field lines. After it moves 180 degrees, it will go back behind the board, which means an opposite direction of crossing the magnetic field lines. And obviously, all depends on how we cross magnetic field lines, because that's the direction of the current changes. So as soon as we do, as soon as we basically cross the middle point, electrons, which used to be accumulated in one end, will start basically flowing back to another end. So the electrons will just move back and forth, back and forth on rotating wire frame. Now, if we have some kind of electricity here, some kind of a consumer of electricity, then as soon as they will accumulate here, they will flow this way, and that will be the direction of the flow. But then when we change, the direction of the flow will be different. So the electricity will go all the way this way and then all the way this way. So it's an alternate current. That's how alternate current is generated. Now, let's talk about this quantitatively. I would actually like to come up with the same formula more or less. And that's quite frankly not very difficult at all, because we can always consider only the moment from time t to time t plus dt, infinitesimal increment. To make it a little bit more understandable, let me just do the top view. So how does the sink look from the top? Well, magnetic field lines are exactly the same way, but as we are looking at the top, let me just put the... If this is my frame, this is A, this is B. If I look from the top, and these are magnetic field lines, the magnetic field lines are the same, but from the top I see only line B, right? So I have only B line, and as it rotates, my B line basically rotates at certain angle phi as a function of t. This is my B, from this point to this point. And my A and its opposite line go behind the board, right? So all this construction is behind the board. So we can definitely say that if this thing is rotating with a constant angular speed omega, then this particular point, P, has coordinates. This is B, so this is B over 2, right? B over 2 times x is equal to cosine. Angle phi, angle phi is omega t. And y-coordinate, this is x, and this is y. And the y-coordinate is equal to B over 2 sin omega t, right? That's simple. Now what we are actually paying attention to is only the vertical component, only y component, because x component is not against, crossing the magnetic field lines. It's only the y component is crossing. So we're paying attention to this, to y component. This is a point where my, this or this side of this wire frame are behind. So this one is behind P, and this one is behind Q. So if we know this, we know the speed. So V as a function of t, as a function of time, is the derivative of this, right? What's the derivative? It's B over 2, derivative of sin is a cosine, and then there is inner function omega, so it will be cosine omega t. So we have a speed. Now if you have a speed, remember, I times L times B, which is I times V times t, whatever times B. So during time dt, during time dt, what happens? We have to overcome the force, the Lorentz force, which acts on this particular rod, which is behind point P, which acts against its movement. So we are moving my point along the circle, but again it's only the vertical component. How it moves across the magnetic field lines is important. And we have the speed as it goes in the vertical direction. So now we can also assume that there is some kind of a current generated by this. We will be able to calculate the amount of work, which we need, remember? So in this particular case, and if we will multiply F times, we don't really need this. If we will multiply F by the certain lengths during which we are moving this thing, it would be I times L times B times dS. Now what is dS? dS is d times dT. Okay? So that's what we have. And on the other hand, this is I times U times dT. That was our main formula. Now, in this case, the L is the length of this rod, which is A. So we have I of T, because obviously the current is changing since we are changing the speed. L would be A, B would be as it is, V would be over 2 omega cos omega T and dT. And that should be equal to I of T times U of T times dT. So this is the power of the electric current, which is generated times time. That's the work. And obviously we have the same thing here. dT also goes here. And what do we have now? We have that our voltage, which depends on the time now obviously, is equal to A times B over 2 times B times omega times cos omega T. So this is the voltage generated by one rod behind this one. Another one does exactly the same thing. And so one is generated a certain amount of voltage in the other and they are connected sequentially to each other, so voltage is added together. So the total voltage will be equal to double, basically. It's A B times B times omega times cos omega T. This is the total voltage generated by the wire. By the wire frame. Now, does it look like this? Well, yes. And it's very actually simple to make sure. What is the area of this? The area of this is A times B. But we are not talking about total area of the wire frame. We are talking about only the area which is crossed by magnetic field lines. So we need actually only this area, the projection, if you wish, of the area onto this vertical plane. Which means it would be what? If this is completely this way, the projection is zero, and as we are going, this thing is increasing as a sign of this angle, phi of T. So basically A times B times sin phi is the area which is visible from this direction from this point to this point. And so this is basically a flux. If you multiply it by B, right? By the magnetic, intensity of magnetic field. And the derivative of this is equal to the derivative of sin of, this is the function of T, right? So it would be A times B times phi of T is omega T. So derivative from the cosine is, from sin is a cosine. And in the function omega T, so it's omega times cosine omega T times B, which is exactly this one. So we can say that U is equal to, well in this case U is electromotive force, which depends on the time, is equal to, I will use this minus again to signify that it's against the movement. So as we are moving our wireframe, as we are rotating it, there is a resistance which is caused by Lorentz force basically. But as a result of our movement, our doing some work actually, there is electric current which is generated, which can in turn produce its own power and work. And that's what we are using on the consumer side. Obviously if we are spending some energy by rotating this energy is converted into the energy of the electric current and that's what we are consuming. Well, basically we are coming up with exactly the same, this is T, magnetic flux. So magnetic flux, change of magnetic flux, speed of change if you wish. Well, the first derivative, speed of change, rate of change, whatever. This is the source of electromotive force, voltage which is generated and can be used. Okay, that's it for today. Thank you very much. I do suggest you to read the notes for this lecture. And good luck.


I hope you're well. Welcome back to my channel. If you're new here, my name is Sepi. I'll give a brief introduction about myself if you're new to the channel. I am a junior doctor. I graduated from a medical school in London called St. George's earlier this summer in 2020 and I'm now working in a hospital in London. In order to get to where I am, I had to sit several exams. So high school exams in England are called GCSEs. I had to do those and get good grades. I did A-level exams. It's the exam we sit before we go off to university. So it's the grades that we get on that which kind of gets us out of place in university here in England.  So I think by this point, I kind of know a thing or two about revision and I just want to share my knowledge with you guys because this is probably the most requested video and the most requested DM I receive is how to study and a lot of you guys message me saying how can I study for GCSEs? How can I study for A-levels? And how can I study in university? So I'm going to cover all of that because I feel like it's the same methodology for all of them. I'm going to try and be as efficient as possible. I don't want to like blabber on for ages. So I've written down everything that I want to talk about with you guys on my phone. So I'm just going to go through one by one. I basically have seven steps to this or seven tips for this. So I'll start with the first one. The first step is to do with timing. Do you have months until your exam or do you have a month or a couple of months until your exam? So figure out your timeline of how long you have.   I personally am the latter and I have a feeling that a lot of you guys watching this video are also the latter. Because people like me who prefer to study mostly in the last two or three months leading up to the exam usually question themselves more because they look at the people who are studying throughout the year and think I just couldn't do that. The reason why I don't like studying two hours a day throughout the year is because I feel like by the end of the year I would have forgotten everything that I studied at the start of the year and so it just wouldn't be efficient for me and I just would always be worried that I'd forgotten everything. So I much rather study like 10 to 12 hours a day. Honestly, there were days where I'd study 16 hours a day, it really wasn't uncommon for me. So I could study 16 hours a day and be doing that for like two or three months. So decide for yourself what kind of person you are and that's the first step. Now the second step is to write out everything that you need to achieve and the dates for it. So for example, if you have a history exam in July, write down history exam, paper one and paper two, July 2021, for example, write out every single exam you have and the dates for it and how long you have until that date. So let's say if you've got eight weeks, you can write that out next to where it gives you a better idea when it comes to the next part which I'm going to talk about which is scheduling your time or organising your time. If you write down a sheet of paper, everything that you need to do and how long you have to do it, it gives you a better idea in your head of how you're going to manage this and you can then write that down as well. So I'll give myself as an example. If I have a medical exam, let's say I am doing my medical school finals and it is in December 2020, so that is about two and a half months away. So I'll say 10 weeks till medical school exam finals, then I will then underneath that write down every single subject that's underneath the medical exam finals. So for example, respiratory medicine, cardiology, endocrinology, ophthalmology, general surgery, and then I will then write how many weeks I want to dedicate to each topic because I'll write next to general surgery, I'll write for example, one week next to respiratory, I'll write two weeks next to cardiology, I'll write two weeks. So you'll know how much time you have, how much you want to dedicate to each topic and it gives you a better idea in your mind when you look back at this, if you're running on track with this or if you're kind of too far behind or if you're ahead of schedule, it's really good to give you an idea of where you are with your revision. Now when it comes to actually getting down to revision, I think it's really important that you set yourself daily goals. So every night before you go to sleep, write a list of everything you want to achieve the next day. I still do this to this day for just daily life activities. So I go on my phone and I make a list in notes, like a tick off list of everything I want to achieve. So you could go on your notes and you could write for tomorrow I want to do two hours biology revision or two hours chemistry revision or one chapter of biology, one chapter of maths. So decide for yourself what is feasible for you and write it down so that you make sure that you achieve it in that day. When you wake up the next day, check your list in the morning, then go ahead with doing the list. And then at the end of the day when you're done, make sure you check the list and see what you did achieve and what you did and why you didn't. Maybe you were overshooting and thinking that you could do much more than you could. Maybe the subject was harder than you thought it was. Maybe you were just having an off day, but make sure you reevaluate because it makes your list more and more efficient every time. And when you get your list, things on your list done, it gives you such a better feeling of achievement and it makes you much more motivated in order to actually study. Now the fourth most important tip is to figure out how best you learn. Are you a visual learner? Do you learn from watching YouTube videos, sitting in a classroom and having a teacher draw things out on the board, drawing spider diagrams? Are you an audio learner? Do you learn better from hearing? So just listening to people. Are you the kind of person who could read something and can understand it much better than someone talking to them? So decide are you a visual learner?  Are you an auditory learner? Do you like to do spider diagrams? Do you like to write? I personally like to write things down. If I don't write it down, I haven't got that engagement between focusing and my hand moving and it going into my brain so I don't learn. And I actually had a talk in my first year of university by a neurologist who said that people who take notes whilst learning are much more likely to be able to remember that information later on versus the kind of person who just sat there and listened. But decide for yourself because maybe if you're sitting and focusing on listening to the lecture or listening to the YouTube video explaining your topic to you, you're much more likely to learn and engage than if you're busy writing. So decide for yourself how you learn best and use that to your power. So if you are the kind of person who learns best from visual stuff then make sure you can watch lots of YouTube videos about learning your topic of choice or make sure you listen harder in the classroom because it will definitely help to speed up your revision process. Fifth thing I wanted to talk about is note taking. I think when you take notes it's really important to make it as appealing to read for yourself as possible. So make sure that you don't write too much. So just highlight the most important key things. Make it colorful. I think using colored pens or highlighters if you're like me, I can't be bothered to swap pen colors so I just write my notes and then I read it and highlight the important bits. And third of all using visual aids, spider diagrams, these can all help with not only learning the information at the time but if you want to come back to your notes. I've got my notebook here from when I was in medical school and I've just literally flipped open halfway through. These are some psychiatry notes so as you can see I've got a lot of color. I've got really small handwriting, some of you might have larger handwriting so it might seem like I've got so much on the page of you guys but for me this seems like a good amount of work on the page. I've obviously flipped my book horizontally so that I can fit more into my spider diagram and pretty much the whole book is like this. It's a perfect book but this is how I learn best. So yeah that's definitely one tip. Also another tip is keep all of your notes in one place so I've got this book in uni. It's like these dividery books so you can divide it by each topic and all of your notes are in one place so you can just flip through and in between and they're all in one place so you don't waste time going around and looking for notes. And then the last tip I have for successful provision is practice, practice, practice. No matter what exam you're taking usually there is some sort of online past paper resource or some sort of online question bank or books with practice questions in them. The more practice questions you do once you've done your revision the more prepared you'll be and the more similar it will be to your exam so you will be much more focused and in tune with how to answer your questions and relate the knowledge you have to these questions. So practice, practice, practice. If there's one thing you take away from this video, practice, practice, practice, write it down in the comments, practice, practice, practice, don't forget that that really helps. There's no point doing questions if you haven't done your revision but let's say you do chapter one of maths and there is some questions at the end of it. If you do those practice questions you help to consolidate your memory what you've just learned so it really really helps. Now the last few things I'm going to talk about are all about motivation and efficiency. So loads of people ask me how do you motivate yourself to study and how do you remain efficient because sometimes I just can't be bothered. The most important thing to take from this is to recognize when you are tired and to take a break because sometimes we think we sometimes we go too hard and we get tired or like I just need a break now. So if you if you schedule your break so for example you say um after 10 o'clock I'm not studying anymore I'm going to take that time for myself and watch movies and not feel guilty about it um but I need to work before 10 o'clock then that will definitely help you to kind of feel a balance of not having burnt out. As well as taking breaks I think it's important that when you are studying you give it your full attention. The easiest way to do that is to chuck this thing away. Mobile phones are so distracting when you're revising. When I did my secondary school and sixth form exams so that would be the equivalent of like high school for America or other countries. When I did my high school exams I didn't have Facebook, I didn't have Instagram, I didn't have Twitter. The only thing I had was Snapchat and even then there was no stories or anything like that so I really was lucky but I feel now that there's so many of these apps around um if you have your phone there's so much more like you to be distracting for you so put your phone in a closet in another room on silent. Text everyone that you need to text and tell them that you're not going to be on your phone for a few hours um and if they need you they can contact you in an emergency via the landline for example um but put that phone away because it will definitely keep you efficient and it will make sure that when you do take a break it's for the right reasons and you haven't actually been sitting at your desk on your phone the whole time. I remember I used to go to the library and I used to see this guy sitting in the library um on his phone watching like football or rugby and I was like why are you sitting in the library and wasting your time? You're tricking yourself because you think just because you're in the library that you're doing something efficient but actually you're not being efficient you're still going to come out a bit tired because you weren't fully relaxing but you also weren't fully revising so be efficient and I think the last thing is definitely about motivation so the key to motivation I think as you get older it gets a bit easier because when you go to university you usually pick that exact subject that you're going to study so it's much more easier to motivate yourself to study um and even if at that point it's difficult I think the most important thing in terms of motivation is to remember your end goal so I would always remind myself why I'm studying so I'd be like you know I always knew I wanted to do something medical so I wanted to be like probably a doctor when I was in high school so I was like if you want to be a doctor you need to do well in all of these exams so don't forget that that's why you're doing this no matter how boring or repetitive it may be how good would it feel when you get those good grades just picture you getting those good grades how amazing would that feel when you have that to put on your academic CV for applying to university how good would that feel and when I was in uni and I would lack motivation or I was feeling like I was burning out I'd take more breaks uh but I definitely just remind myself why I'm here and why I'm doing this one doing this exam how far I've come so um just reminding myself you know this isn't just a moment this is years in the making and I owe it to myself to always do my best and just a few important quotes so my favorite one is some people dream of success others wake up and work hard for it so whenever I was lying in my bed taking a nap when my alarm would go off I would want to snooze it but I'd remember that quote and I would just jump out of bed because I was so motivated and I was like no I'm not gonna be a dreamer I'm gonna be like a someone who succeeds so definitely have a few good quotes in your little library to remind you why you're doing what you're doing I hope that you guys found this video useful if you did then please give it a thumbs up and leave me a comment down below and if you want to see more videos like this then don't forget to subscribe to my channel it really does mean so much to me if you do so thank you so much in advance if you want to check out my socials they're always linked down in the description my instagram is persian bunny and my snap is stephie sam I love you guys so much and I'll see you next time bye


In this video, we are going to look at how to add retime to our blogs. We're going to do this to our blog post using the Elementor Loop Builder, and we're going to add them to our blog templates as well. We're going to use two different methods. The first one, we're going to use JetEngine, for all of you out there that are using CrocoBlog. The second method that we're going to use, we are going to use a free version of advanced custom fields. So I do got timestamps inside the description, bounce to where you need to get to, to get the right information. I'm going to make this one pretty quick and easy. And if you do like this and find it helpful, you know that good YouTube stuff. Make sure to like. And if you want to keep updated with content like this for web designers and creators, then make sure to subscribe. All right, let's jump in. We are going to start with advanced custom fields, and we're going to be using the free version. Go over to your add plugins, and just type in advanced custom fields. And we're looking for this right here, ACF. So I've already installed it. I'm just going to activate it. Now here we have this option for custom fields. Our left sidebar, let's go ahead and click on that. From here, we're going to select on add new field group. And let's go ahead and give it a name. We're going to call this retime. All right, now here we have the option for our field type. This is going to be what kind of a field goes inside a blog post. And the field is going to be a field where we could fill in the information. So we're going to want to change this to number, because we want there to be a number that we could add for the number of minutes. Let's go ahead and change the fill label to, again, we're going to call this retime. Fill name automatically populates. Now, a default value. This is totally up to you if you want to add something. If you put a value in here like zero, all of your fields are going to start off with zero. So in the front end, right now, if I were to add it, all my blog posts would show zero minutes retime. Now, I probably will leave this one blank and only fill it in. That way, only accurate information is getting put out there. But for the sake of this video, I'm going to put three so that way you could see how it works inside the front end. From here, now we have our settings and the settings are already set up good to go. This is going to be for a post type, which is WordPress default post equal to and post. So it's all good to go. Now I'm going to go ahead and save the changes. And here is one of my blog posts right here. Now, all the way down here at the bottom, you can see the custom field. If you do not see this custom field, then something went wrong. Go back through and make sure everything was done right and everything was saved correctly. Now with this set up, we are good to go to add it to Elementor. We're going to start off with a loop builder. So that way we have it in our post grids. And then we're going to go to our blog template. I'm going to be using this demo website right here. And I have my loops right over here. It's not that pretty. I just did something really quick and simple. So let me edit this. Now select on edit template. And from here, whatever we add in here is going to reflect for the rest of the post grid. I did make a video on the loop builder in case if you are new to it, I'll go ahead and leave a link somewhere around here. All right. So now we got our title, our button and featured image. Let's add in our read time inside here. I'm going to go over to my widgets and I'm going to put post info. I'm going to slide this right down below the title. Let me undo all these. I just want one item. I'm going to change this type over here to custom. Now in the custom, we're going to select on dynamic tags. And here scroll all the way down to our ACF and we're going to add on ACF fill. Now click on this right here where it says ACF fill. And we're going to have this drop down for settings and underneath the key, we're going to see the one that we created, which is our read time. Next, we want to go to our events and we want to add in our before and after. So I'm going to put in right here read time and I'm going to create a space right there. And then on after, I found what really helps out create another space right there and start it. And I'm going to put just men. Next up, I want to turn off the icon right here. So it aligns to the right and then I could go ahead and style this up. Let me go ahead and do that. I got my styles all here makes it really quick to do. And I'm going to add some spacing here. We'll put 20 pixels, give a good amount of spacing. Let's go ahead. You can select on update right here or you can click on save and back and it'll do the same. And there we go. Now we got the read time across all of the blog posts and you can position this any way that you want using elements or loop builder. That's why I love loop builder. This thing is awesome. You can put this way up here. You can do anything. You can make it go sideways. All right. We're not going to go there right now. All right. Really quick. Let me show you how this all works. So if we look at the front end, we're going to see three minutes and we got finding your ideal client right here. So I'm going to go to that blog post and let's say this one is a very small blog post. So I'm going to put on just one minute. Let's update that. We can refresh it. And there you can see we have our read time. All right. Let's now go add this to our blog template. So that way when we see a single post, we have it right there. Let's go over and create a template really quick. We're going to make a really fast one. Now from here, I'm going to add new and I am going to add a single post. I'm going to call this one my blog template. And I'm also using the old school theme builder. You might be using a newer one. I personally like this one a lot better, but it's the same exact thing. You're going to create a single post. And now this is really important. Do not use these pre-built templates. They're really old and outdated. They're not compatible with where Elementor is now. I'm really hoping Elementor removes them and build some new ones soon. They have some new ones inside the works for containers. So that's good news. All right. Let's go ahead and click on our container right here. Let's do everything inside a single container. Now build in a blog and build in the template. You don't have to create many different sections or containers. You can do it all in one. All right. I'm going to do this quickly. Now let's add the title right here. Let's add the featured image right here. Where is it at? And then right underneath that, we're going to add our post content. All right. We can style this up really quickly. Let me center align this. I have my styles. So I got my color. We're going to make this large right over here. I'm going to make this a lot smaller. I want this to be boxed in. We're going to make this at 800. I like my blog post to be narrow. It's a lot easier to read. All right. And then let me add some spacing here. I'm going to put 40 pixels below to get some proper spacing. And let me fix this up as well.  And then I got my body text right here. In fact, I'm going to make this more narrow. I'm going to make it 650. All right. And now I want to put the read time and author right here. So let's go back here and let's put the post info widget. And let's remove two of them. We could keep the author. I think the author is cool to have for the date. Let's go back and do the same thing that we did. We're going to change it to custom. We're going to select on dynamic tags.  Click on ACF filled and select on read time. We're going to do the same in the advanced. Before we're going to put read time. Add a space as well. And then after start off by adding a space. And we'll put men right here short for minutes. All right. Now for the icon, we do want to put an icon right here. Because it would be kind of cool if you want to pull it. You don't have to. I'm going to go here. I'm going to put time. And let's see. Do we have a watch? A clock. Here we go. Now let's go ahead and style it up. We're going to make our icons this dark blue. Our text this dark blue. And let's go ahead and get that. And then we could center align that add a little bit of spacing. All right, you can see I'm geeking out now, but I like to show a bit of my design process. Now I will go ahead and put some spacing around here. I probably put like 20 pixels all around. And then the top and bottom would do 80. This is what I normally do for a blog post. And we have our read time with our author right here. Super easy. Now let's jump over to jet engine because it's very similar. Let me go over back to my plugins. I'm going to activate my jet engine from here. Now I'm going to go over to meta boxes. And the meta boxes are going to work the same as a custom field. So I'm going to click on meta box. I'm going to add a new one. I'm going to call this one read time. And we're going to keep it on it for post. That's what it's for. I want to put on edit the meta box link. There's a few more options here. There's a few more than the ACF and some cool things that we could do as well. Now let's enable it. And we're going to select on post. Now we need to create our meta field. Same thing as a custom field. Select on that. Let's go ahead and give it a name. I'm going to call the read time. Oops. Same thing auto populates. We're going to keep this as a field. I want to fill just something easy to fill in. And same thing right here is ACF. We got these options. And I want to change it from text over here to number. Where is number at? There we go. And as we go, you can see there's a lot more options over here. So we could put a minimum value. Maybe two is the lowest out of a go because no blog post would be less than two minutes. Or you could also put the maximum value. Say you don't want to go in past 10 minutes. That way nobody can make a mistake saying hey this blog post is 100 minutes. Nobody would ever click on it. All right, we could put in our description. This is the read time. We could change our fill width. We're going to leave it just as it is. And then same thing as ACF. We have our default value. I normally would leave a blank for this tutorial. I'm going to change this one to five. So it's more identifiable in the front end. Easier to see as you are learning this. I do like to turn this on the quick edit support. I'll show that in a moment as well because it's super helpful. Now I'm going to click right on here at meta box. We got it. Now let's go over to our post. If we refresh it, we should see it down here if we did everything correctly. You can see our default is set at five minutes. And now that we have our meta fill set up custom fill meta fill. Same thing. We could go now back to our homepage. Let me refresh this right here. And we're going to do the same exact thing that we did with ACF. I'm going to go over here and edit my loop builder. My loop. I am now going to add the post info. I'm going to drop it right here. Let me take out all these. I just want to put read time. I'm going to now take this down to custom. Select on dynamic tags and scroll all the way down to the bottom where we can see our jet engine options. And we are going to select on custom field from here. Now you could if you don't see this, you could just click on it. It'll drop down. We're going to select now on read time. And here we're going to go to our advanced. We're going to put in read time out of space and the after start off with a space and we're going to put men right over here.  Let me make this one blue out of my font style right here.  And now we could see our read time. On everything. And if we go back to it, so we got five minutes here. Let me go ahead and edit this. I'm going to put two minutes right here. Let me update that. Let's refresh this. And now you can see we got two minutes. Now, if you are wondering, well, how do I find out the actual read time for a blog post? I got this really cool tool right here about to show you. In fact, my man Ben, that's from the Lightbox crew. He's the one that showed me this tool. It is the Read-O-Meter. It is completely free and I'll leave a link to it inside the description. Basically, let's just go here. What we could do is copy and paste all the text. I'm just going to scroll, capture all of this, copy it, paste it in here, select on estimate reading time. And there we go, seven and a half minutes. Probably will round it down because people don't want to read long blog posts, but it's completely free, really helpful. Also, in case if you're wondering, well, why not use a plugin? Because there are plugins dedicated to adding reading time. The thing is using custom fields or meta fields like what we did inside this tutorial will allow us to be more creative and have more flexibility on how we create our post grids and our post templates because that's the power of using a tool like Elementor or even Bricks. Using this method, it gives us that flexibility and it is a really good practice and habit to get familiar with using custom fields and custom post types. Well, I hope this video helped. If it did, you like content like this, make sure to subscribe, support the channel. It is much appreciated and I'll be back again soon. All right, thank you.


Thank you, Graham. Now after excellent presentation, my pre-speaker. I will bow academician. I apologize. And there are two words which probably you are not known to everybody. It's the environment. The environment, I organized in 2009 during Czech presidency the conference to environment. In parallel, it was in Paris the meeting committee of ministries and they define principle of e-democracy for environment. You see that it is a use of information communication technology for purpose of environment, assessment and protection, spatial planning and sustainable use of nature resources including public participation. E-environment belongs to family e. It means e-participation, e-government and we mean that it's one of the pillar of e-democracy. Well, but it's very short principle and committee of minister did explanation memorandum and they define other principles of e-democracy for environment. It's more understandable that the environment includes the use of ICT based system for access and dissemination of environment data and information and as well establishment IT supported monitoring system of environment and repository to increase environment knowledge. It's not enough principles. Other principles is connected with the spatial planning and at the Europe we've got inspired directive for the spatial information and it's also the pillar of the environment and last principle is Arhus Convention. Arhus Convention has a basic motto of e-environment. It's access to environment information, public participation in decision making and access to justice in environment matters. I lost some slides, never mind. There was a picture of two things. One is how it is connected to e-environment with single information space. We mean that single information space is following of single information space for environment, is following of single information space as the part of Lisbon Convention and now is the part of e-European 2020 strategy and, of course, digital agenda for Europe. When we specify technically conceptual of the single information space for environment, named CSET, we have to consider in solving FB7 program, it's ICT Endurer project, that it's not only ICT infrastructure. We have to consider as a policy space, organization space and mostly legislation space, content and technical space. There is a connection between e-environment and CSET. E-environment is connected with environment, we mean that European 6 environment action plan, environment police review and now digital agenda for Europe and it's supported by FB7 project, which I mentioned there. The newest is future internet and there are plenty of conferences devoted to this topic. I mentioned terrace environment, which was organized in 2009 in Prague. Also, during Belgium presidency, it continues in conference sharing environment information system and as this conference is a new phenomena, new paradigm, it's open government data. I organize this June, other conference divided to e-environment, frameworks e-environment, where one section was devoted connection open government data initiative, where Microsoft introduce Azure and also there was presented open data initiative by marketing algorithm from Austria. Digital agenda for Europe use that term e-environment enlarge as e-environment services. It belong to e-government services, but there are still under development, unsure and unfinished. And there are supported by law, it means law connected with Arhus Convention and development of share environment information system of European Union and inspire directive. And in the plan is the review of directive on public access to environment information. In morning session, this direction, and also public administration, public approach to information which is connected in public administration. And also it's necessary support cross-border environment services used interoperability and member states could be stakeholder for implementation of cross-border environment services. And now there is big development of sensor networks. You know the initiative, global monitoring environment and security system, global earth observation system of system which could be use the Galileo and so on. And I summarize conclusion of our conference which you can find at my speech that I inspire on, it's now at the YouTube that it's necessary to establish national regional environment information web center for environment in member states, European data center for environment was established. And now I mention here also cloud computing Microsoft develop for air watch and water watch web page. It's I on Earth where you can find for the whole Europe data, current data from the monitoring system about air pollution. And also this water watch is the system which where you find the swimming pools and recognize if possible there are to go to swim or the water is polluted. It's necessary to educate also the skill of human capacity to use ICT tools and internet which are developed through the single information space for environment, shared information system, global monitoring and security system and GOS. And commission now try to develop institutional capacity and for example in our university we prepare the special center for air pollution with heavy toxic materials persistent organic pollutant. And it's necessary to ensure interoperability and develop and apply comprehensive environment related ICT tools. I think that we don't have enough time and I will give the floor to you. Thank you very much.


Hi, I'm Cleo Burns. I'm 17 and we're at City Hall and I'm registering to vote for the first time in the primary election. I walked in and they have a spot that has a sign saying voting. I went up and said I was here to register to vote for the first time and they gave me two different forms that were basically just filling out date of birth and the my current address and billing address and contact information and so I filled out those forms and gave them back and they gave me a ballot and an envelope to mail it in and that was it. I'm registering to vote because I want to have a say in the change that's being made that fix myself in my future and my community in Vermont. I'm Cleo Burns and I just registered to vote for the first time in the primary election.


Hi there, I am Bob the Builder and Yeah, I am fixing up a An electric unicycle that I took apart a couple of months ago because I finally have replacement parts So this is the frame of the unicycle it goes together like that and This is the wheel which has a hub motor inside whole effect wires Phase wires pedals and so I will be transplanting all of this Stuff onto new wheels new board. Oh, yes Here is the old Unicycle battery which is burnt crisp and this is the board which is also burnt crisp Yeah with complete with broken MOSFETs and all So yes Over here, we have a new board and a new motor and so let's proceed Just get the remaining pedal of this wheel. I hope this is the right side It's just the right side. I think it is. Yes. Okay, good Yeah, okay This got the wealth, okay So Yep, let me just put this thing back on so I don't lose it New wheel has all of this stuff anyway Okay, and now we may be damaging the table Should I get wood? How about wood? I Wonder if I should just focus on the other parts first Okay In that case I will need this and I need to transplant this This board onto this Okay, this is the board piece and Okay, time to dig up the manual. All right, so we have installing direction which is Battery connector and capacitors face upwards. So it's like that. Okay. I Am transplanting the board on from the new new aluminum sink To the old aluminum sink because the holes are not quite the same Yes, I bobbed the warranty sticker GG Okay Since the warranty sticker is broken, I'm just going to remove the screw Yep No, you know to use it you have to break the warranty. No, no, no They they gave me the wrong aluminum bore aluminum backing plate and I didn't specify So my fault. Oh My god, this spacer is glued on. No wait Okay, it's not glued on I can remove it. Yeah Okay, and this silicone sheet be peeled. Yes it can Okay, what do you do? Okay? Okay?    Yay.   Where is the spacer? Oh Thankfully we have old screws Please tell me the trains are the same and yes, they are the same Yeah, I don't know. You know what if we get the unicycle running We can get to Mustafa to buy the tire things we will which we will no longer need or really Thanks CJ Okay, let me just probe these things so that I to make sure I didn't Like shot these things So screw to screw Hey, where is sound That's surprising Okay, good it's not shorted. Okay good. We are good here No I This is a friggin comedy skate Where's manual and note cathode, okay, let's see and note of hall cables How to get to the howler area Port of buzzer Port of buzzer And note of buzzer cathode of buzzer Like in 10 minutes. Did they have 10 minutes shipping free 10 minutes shipping? And note of buzzer cathode of buzzer. Oh, yeah, that's correct. Okay, um power switch Power switch connector.  I Pray I don't remove I don't lose another spacer. I hate missing spacers. Okay Open this up Let me get a chair. I swear. I thought this thing will only take half an hour Yeah Basically Oh Thanks, Aaron Okay Now I don't know which screw goes where it's probably one of these. I wonder which one You have to be careful about taking out the inner tire the inner tubing This doesn't look right.  Yeah, really? Yep. No, maybe Who knows? Okay Is there a player here? No Okay, so we have a cracked screw hole thingy here, but hopefully with this zip tie it will stay Fuck, where's the screw? Okay One of from all angles yo Is this like a high high speed camera is this like a high speed camera can we get like high speed shots of it blowing up?  So if you If it shorts onto the aluminum plate, then it shorts together and things die They're all my friends there Really?  Is it north, east wing, west wing, south wing? Just go there and ask them to direct you to the hardware area How difficult can that get?   What if they have their stock has increased Was it Wait a second something clicked I hope nothing broke this time in nothing book I kind of dismantled it, but yeah, who knew that you needed tires, right? Oh, so that you just have the bell yeah, okay You mean ask those random apex on the street with Riding around in neon light bikes Gee Gee I wonder where that is Okay Okay, okay Board is on okay now let me check the manual again 30b controller port of indicated LED's is here Think this is the one No, it's The other way There we do this is one buzzer is to you Now it is is one. It's on the right side. Oh My god these loose wires are scary Okay Yeah, I have no idea which polarity this is. I'm just leaving Three wires out first. So I don't show anything Hopefully I get it right Okay Step one One port of LED's to buzzer Tree is holy fat cable, which is on the motor motor and power button It's not there. It's because you don't have enough strength Okay, the just final look like it was gonna fly Port of whole cable whole cable is like that I know This is all correct Okay, I am done with the board side but can't power it on yet Okay Now to work on the battery Okay Battery I need to take out this connector so that I can get this plate off and this other connector off and Then then we should be good Oh Don't worry I said a lot You can post process the swearing out Oh It goes from G to PG to mc16 then to everything then to R21 Okay, let me get soldering Forgot to buy new flux Okay, no, that's fine, I think Let me just place the actual shot for my much man Yes, please Okay in the absence of a clamp Masking tape stuff to the table shit. It's the wrong side. Okay like this Okay Yeah Soldering iron I Am trying to refresh the tip. This is a tip refresher or something. It makes the tip nice and silver again Power connector battery. I have to get the displayed out Can't get it out without disordering this thing. I had to cut the wires or I desoldered it. I Am picking the latter option. Are we not hot enough? 400 Yes, of course One always talks to his soldering iron. Don't you know? Come on. Come on. Hmm vacuum thingy. Oh Come on out. Hmm. That's not silver. But yeah, something like that Oh No solder, let's shift this a bit. Whoa. I'm not scared. I'm not scared. I'm not scared Shush, I'm trying to convince myself Doesn't work man. I'm high on caffeine. It's so awesome to be soldering on caffeine It's like your fingers just jiggle around and the soldering iron doesn't meet its mark Nah I thought someone said he wanted to get it done before CJ returned Yes, we're out One wire is out. Let's get the other one out. Yay Uh-huh Yes, well the alternative is to No, no


Hello, my name is Phuong Nguyen and I come from Vietnam. I have graduated from the 2020 International Business Management, BA program from Teaside University. My project was previously investigated the potential of a luxury market in Prague based on the purchasing impetus of multicultural young women for high-end products. Specifically, it was to explore the impacts of trends and psychological factors on conspicuous consumption in connection to the social values and cultural dimensions. The results of the project suddenly benefited many stakeholders in the field of luxury products, such as the marketers, owners of high-end brands, craftsmen and the government. The conduction of the research was performed by the usage of questionnaire based on quota-sending and interviews by non-standardized methods. It was done in the capital city of the Czech Republic, where I solved data after a certain demographic that had the experience or knowledge in regards to purchasing high-end goods. Moreover, I also required quality data from experts and brand owners that were involved in such industry, as they provided a unique perspective and bias in regard to mechanism behind conspicuous consumption. Unfortunately, the products faced difficulties in carrying out the methodology previously as the world was impacted by the first wave of the viral outbreak known as COVID-19, which has highly influenced the progress and the data collection of my research. Because of it, the local government has imposed by law self-isolation during the pandemic, which has hindered my ability as a research to commit physical interactions with potential participants and interviewees in order to collect quantitative and qualitative data. Therefore, I had to adapt by using the contingency plan, which meant that I had to reach to the online platforms, which consist of users that were living in Prague. Despite the difficulties, the research findings suggest some specific preferences of young consumers from different countries in the way they make purchasing decisions. In particular, young Asian women tend to invest in high-end cosmetic products. Americans would buy luxury drinks and food, while other customers from European countries are likely to buy high-end fashion items. Such buying decisions are mostly driven by their cultural background, social economic position, the current trends in the market, and psychological impacts. By analyzing the differences in the shopping pattern of young women from different cultures, the research would be beneficial to luxury brands in targeting consumer groups and to the government, as many of the individuals participating in the research were tourists who would not only come to the country for the luxury shopping, but also for other services and activities.


Hello, Welcome to SSunitech, so we will decide and today we are going to see about the parse transformation in the SEO data factory. So before going forward, if you haven't watched the last video of this video series, so I would strongly recommend to watch that video where we have discussed about the Stringify transformation. So what is parse transformation? Use the parse transformation to parse text column into your data that are string in the document form. The current supported type of embedded document that can be parsed JSON, XML and delimited text. So these are the supported format that we can parse. So what is the parse transformation? Let's see in the practical, so you will have the better understanding. So here, if you have seen in the last video, we have loaded the data from the source to this table which is the sales rotable. What we need to do here, we need to parse this item into two column like the item 1, item 2 for this, item 5, 6 and 10 for three columns. So in the destination where we want to load the data in the below table, we can see the item 1, item 2, item 3. So from this data, it will be parsed into three columns. Similarly for the address, it is having like city, state and country. So this data will be going to load into the city, state and country. So this JSON will be going to parse into three columns here and this item which is the delimited text we could say with the comma delimited. So this will be parsed into three columns with item 1, 2 and 3. So this is the actual use of the parse transformation and this is very useful while we are going to deal with the XML or the JSON or the delimited text of any column. So let me go into the Azure Data Factory and we will try to implement this in practice. Now let me try to add a new data flow. So let me click on these three dots with the new data flow option. Here let me call this data flow as data flow of parse transformation. So that is for PS. Now first we have to add the source. So as we have already seen the source is the SSMS table which is the sales underscore raw table. So let me try to click on this add source. For that table we have already created the data set. So let me try to add the data set here. So we can see this raw. Let me try to open this so we can verify. So this is pointing to the Azure SQL database and the table which is the sales underscore raw. So the same table. Now here let me try to go in the data preview and try to refresh. So we can verify the data as we have seen in the source. So as we can see it has all the data. Now let me try to add the parse transformation first. So this is the parse transformation and let me call this parse transformation for PS underscore items. Let me go here. In the items as we have already seen we are having the delimited text here and it has total three columns value. Now so here it is showing error because we have used this underscore. Let me remove that and go back to here. So here input stream that is the source one that is okay. The format as we have seen for the item that is the delimited text. So we have to select that one. And after that in the delimited text setting let me open this first row as header. So we are not going to select that one in the column delimited that is the common. So everything is okay. Let me try to close this and here we can see the column. So either we can create a new column or we can modify in the existing column. So that we have to select over here. So I am going to select the items here. Now under this expression we have to write the expression. So the expression like from which column we want to do the parse we have to select here. So that is the items column. So from this column we are required to do the parse. So here let me call this with the parse. So let me use the ps after these items. So this new column will be added in your output stream. Here we can see the output column type. So here let me define the complex type. As we have already seen we have total three columns. So let me call the first column value as item 1 as what will be the data type that will be string. We can put the comma second for the item 2 and after that let me put the string as well similarly for the item 3 as your string value. Now let me save and finish and here let me go in the data preview and try to refresh it. So it will be going to have the data with three different columns for the item that we have already seen. So as we could see here the item 1 value which is the I1 that we can see which is hidden here. Second for the item 2 that is this one. Third is for item 3 for the first row we did not have the item 3. Let me verify that here we have only two items and here we have three items. So that is why here we can see none and here we can see the value. So this is we have passed successfully for the delimited text. Similarly let me do for the JSON format let me try to add a new pass because if we can see in the pass setting here we can select the format only once and we can add the multiple columns but the format that should be the same. So here we are going to use the JSON. Similarly we can do for the XML as well. Let me add the pass transformation and this pass transformation for the JSON one. So let me call this as country underscore we are not going to use we can directly write PS. Now the incoming string that is okay here the format that the JSON here we can see the JSON settings. So the document form is the single document we can select that one. Let me go in the columns now like which column we are going to create any new column or modifying the guesting one. So I am going to create a new column with the output new. Here under the expression we want to do the pass for the address column this time so we can select the address and save and finish. Here we can see the expression. So again we have to write the expression here similarly we have done in the item one. So CT the data type that is the string. Second for the state data type as string country data type as string. So this will be having three columns. Let me save and finish. Here let me go in the data preview and try to refresh it. So it will be going to have three columns there as well. So we could wait here we can see like the last three columns this is for city this is for the state and this is for the country. So these three columns are added here. Now everything is okay. So this is very straightforward we can say like in the part setting we can select the format and after that we can select the column by which we want to do the pass. So under the expression we have to specify the output column we can select here either we can modify the existing one or create the new one. So I have created the new here then we have to specify the columns with their data types that will be passed. Now we want to load this into the SQL Server table. So let me add this thing here and after that here we are required to select the data set. So data set can be selected because I have already created the data set for the same. So this is the first one data set that we have created for this. So let me try to open to verify the same. So this is pointing the same server and database and the table which is the sales underscore final and here the table which is the sales underscore final. Let me close this go to the mapping and auto mapping we have to off and here we need to do the mapping. So here we can see item one item two item three. So we need to select the item one item two item three. So this is under this column which is the items underscore ps. So let me add the item one from this similarly for item two and similarly for the item three. Now here we can see the city state and country. So this is coming from the address. So address column is having all this data. So that can see address new first is city. So we can select it second is the state. So we can select the state from here. Similarly for the country we can select the country here as well. So we have done this mapping successfully. Let me go in the data preview and try to refresh it. So here as we can see we are having all the data as per our expectations. Let me try to publish this and after that let me try to add a new pipeline to execute this data flow. Here for executing the data flow we are required to use the data flow activity. So we can drag and drop it here. So publish is completed. We can select the data flow that we have created. So go to the setting and here we can select the data flow which is data flow underscore ps. This is we have created. Let me try to execute So after completion of this execution your final table will have the data. So as we can see it got executed successfully. Let me go in the ssms and try to execute this query again. So here as we can see the data is successfully loaded into the destination table and this item which is the comma delimited passed into three columns that we can see and this address which is the json is passed into three columns which is the city state and country. So we are successfully loaded from this format to this format. So thank you so much for watching this video. See you in the next video.