It's actually chicken feet doing this. So now this is like a cow soy salad almost eat the flower, bro Eat the flower. Can you eat the flower? Oh? Oh, it's here in St. Mark's in East Village and are the owners from Dome Bay The logo is a char chicken foot. They've got food from all over Sichuan.  They got different locations one and flushing But this is their St. Mark's location if you guys look at the spread here We're gonna talk about the skewers in a second But you have Guo Baorou. You have the surf clam salad. You have the Sichuan French fries. She called it Langya Tudou, wolf teeth potatoes, and then you have lati ji. They have boneless and bone with bone Okay, and then you have kind of a kanto dish, which is the stir-fry in soup. This is more like a tatanteng dish Yeah, but let's take a look at the skewers. Oh my goodness. You've got Shao Kao right here This is just the straight piece of western bread not even a mantou. Yo check it. They got the this is their Chongyou Bing It's super thick. Oh My goodness you got shrimps all different types of things. They got a liquor license here All right you guys we got a dig into some of the food here at A-roll like we said it's a chain from China But it's been sort of locally adapted even the flushing location is gonna be different from the East Village one All right, you guys of course I got to lead off with the signature dish their logo like a deep-boned chicken foot So this recipe for the chicken feet is the same marinade as the one in China So this is the one thing that they keep consistent to the American version Here's guobao roe.  It's pretty good. Mm. So the guobao roe is good. That's a very Dongbei dish Let me try the instant noodles right here. This is like your Chao Shao Ting Gong Zai Ming dude. What do you think about how everybody it's almost like a greatest hits of all these different provinces You know Guangdong, Sichuan, Dongbei. I feel like everything's getting mixed up now and again This is a young girl Chuan lamb skewer Damn not gonna lie. I think more Sichuan chefs need to cook Cantonese food Is it a hybrid? Yeah, that was fire. Yeah That was like some search one go inside me what I love is that you can eat these little peppers. They're not that hot It's a little bit in here Mmm. Oh, plus there's a pepper down. You start playing There's more of like a Japanese thing, but you know how it is nowadays in Asia everything's mixed up It wouldn't shock me if they had kimchi on the menu too guys, you know how I do with shrimp shell on everything These are not testicles. I repeat The Brussels sprout. I really thought there was a chance.  It looks like that toast got a little Raid on yeah pause Little small on my to me open Listen guys. It's Friday night. We're on St. Mark's come to a roll straight from China. It's fun A roll. This is gonna be a new late-night hot spot. I can tell And which actually means poor in Thai so their drink menu when it gets going is gonna be very crazy and very inventive I'm sure but right here. They got a dish. I have never seen before I've been to so many Thai restaurants This is called latin and this is actually based off of a royal dish and it's essentially like an egg nest that's wrapped around pork and shrimp and Then you pour this cucumber relish on top and then you have these fried lotus leaf chips with Thai spices And then you have something that is more of a fusion with American strawberries Which is a they call it Tom's strawberry salad So it's a little bit spicy with the tamarind flavor. Maybe it's like a papaya salad except with strawberries So that's interesting.  No, you haven't all right guys. This is a royal dish not necessarily street food but from royalty Mmm got cucumber relish. It's delicious sweet spicy I like the egg that kind of wraps around it doesn't matter that it's in a nest form rather than an omelet form I don't know but I like it regardless. All right, everybody. Let's try this strawberry salad the Tom's strawberry. Oh my god Never had spicy strawberries before by the way Rin is super brand new and it's really vibing in here And I could see this being a perfect date spot lotus chips with Thai spices.  I love it. This is so good All right So now the entrees are here and they are doing things differently first off This is your soft shell crab curry and I just the way they played it and how you're supposed to eat it It's supposed to take these rice noodles put them on my plate over here And then I add all my little accoutrements and kind of make myself a little salad look They even ball them up for you. Don't make me do it right now. I'm just gonna do it And then I top it off with some of this soft shell crab curry You can see all the little crab meats is shredded all up in that Yeah, I might just have to eat it all in one bite. I don't know. I don't know if this how you supposed to eat it That is delicious But then here is a take on cow soy which is a little bit different than your usual cow soy noodles that come in like a noodle soup form and Also like a braised chicken. This is fried chicken and then what they told me to do is to pull a little lime on top of it And kind of mix it in like a salad. So now this is like a cow soy salad almost let's try this So interesting that's giving me more like saucy noodle vibes almost like a spaghetti type With fried chicken on top and it's got a nice spicy kick So if you're in a spice definitely come here last but not least they have the crying tiger ribeye This is one of the classic Thai ways to make steak and it definitely mostly Heavily comes from the dipping sauce right here as you guys can see look at all the spices in this thing I'm about to just lather my ribeye pieces just like that I love this spot because actually all the five different owners and partners of this restaurant come from five different parts of Thailand And as you guys know Thailand very regional when it comes to the cuisine. So I just love the diversity here I would definitely check it out They have some very traditional dishes and they're doing their own take on traditional dishes like the strawberry salad So definitely check our in over in the East Village I'm telling you the food fusions are getting crazier and crazier But obviously the name has a cool ring to it because it's playing off Memphis soul Memphis is big on soul music in country music as well I would say man. Definitely if this idea appeals to you man, definitely check it out man It's pretty interesting and I think that they really are fusing. All right in my hand I have the mac and cheese ramen. Okay, definitely different obviously the Korean flares in there with the ramen And then I have this bulgogi meatloaf sandwich that is gigantic and dripping and It has a fried egg in it. This is a first time for me I've eaten a lot of Asian food out there, but I've never seen something like this. I heard the owners It's a mixed team of owners So there's definitely some Korean guys on the squad and probably some maybe Memphis barbecue guys too. Wow. Look at this I can see some of the gochujang kind of kimchi slaw influence right there And the bun is nice. So let's eat it. Slaw is really nice The bulgogi patty definitely interesting. Here we go guys Try some of this right quick by itself That's good, but I think small a la our chili oil that you go great on this and it goes great on things with cheese So let me just pour a little bit on ba-bong and Get that troughly tingly a little bit flavorful umami oil on top Mmm, that's gets kicked up with that. All right, I'm gonna try the sandwich with small a la. Oh my goodness Memphis soul. It's got that Memphis soul BTS soul big Memphis or even Texas style barbecue in with Korean flavors and I just think that's cool to see I want to see more of it So you guys check out Memphis soul over in the East Village All right next up on new Asian concepts We have this brand new Vietnamese restaurant over here on Clinton Street Which is not a street that has a lot of it authentic Asian food by the way But this is their fall right here. We're at the cloud restaurant guys above us. Look at the clouds. Just look Crazy crazy looks crazy. Um, but yeah, this is actually the broth is gonna remind you more of a northern Hanoi style Fuh very beefy But the noodles are still gonna be southern style because I think that's just what the New York market is just used to But look at this beef That's a big slab right there. Is that the oh, no, this is the fling steak nice and soft and raw It's about to cook right there. Let me just taste it real quick Mmm, very beefy. I can tell that it's stewed for 36 hours. That's how they do it here As you guys know, unfortunately, sriracha has been losing market share since uh, you know They can't produce any so a lot of Vietnamese spots are sick turning to other brands This is a popular one Right guys, this is the cloud Vietnamese foe. Oh my gosh, this slab of beef is crazy I mean, I think that they're doing pretty good for here and to have it here on clean street where there's not a lot of Asian food It's really important. So you need that Asian representation.  This is mixed up nicely with the egg and a lot of the coup accoutrements the greens Let's get into it This is probably a lot of people's second favorite dish at Vietnamese restaurants aside from the foe Well, that is actually really good guys. I think this is one of the better bull block locks I've had in New York City, but right in my hand. I got smaller the shop is open guys It's open for orders click on the Shopify link down below Smala sauce to shop my Shopify.  It's a great finishing oil not too spicy But definitely has that cake Mmm, you know when it comes to Vietnamese food in New York City, but is maybe not exactly Mainstream I mean, it's definitely not on the same level as ramen I think on the West Coast in Seattle in the Bay area.  They're marinated with nook mom. I can smell that sweet sweet marinade. Let's get into it They're super hot. That's why I can't even pick them up with my fingers Wow Nice candy crispy outside almost like a like you get something from the Cantonese roast meat spot. Mmm guys. Come on. They got a soulful playlist You got the clouds above looking crazy. You got great ties tea. You got very solid foe You have a great bullock lock. I mean this is what Vietnamese food in New York is like right now So I hope they do well. It's a brand new spot very vibey Our next new Asian concept in New York City is actually a brand new Arabica coffee Location over here in no leader you guys they are entering the American market, of course originally it is from Kyoto So I'll tell you this it is not cheap coffee, but it's very high quality 625 for smalls. This is a matcha This is a Kyoto latte, and then you have a ham and cheese croissant here. It looks beautiful So I got to tell you guys the vibe is impeccable. It's mostly white very clean a lot of hipsters very artsy people here Tones of green got a little greenery plants in there, but overall really cool space. I'm excited All right starting off. We got the Kyoto. I got to stir it up and ruin the art. I'm sorry Pretty good man very smooth 625 no that is pricey. All right guys here. We got the matcha latte. You guys know what it is Let me just drink it right now as is To stand out, you know, I'm not a huge matcha latte fan David likes matcha latte is more than I do But this one is hitting let me try the ham and cheese croissant with a little golden eyeball in the middle Looking beautiful Very aesthetic Mmm.  I'm not gonna lie Mmm for being probably the most expensive coffee chain per ounce in the city I guess is it worth it? I mean I think the quality of the decor The vibe is is on point. Does it taste different? Can I tell as a non coffee aficionado? I cannot tell how elite the coffee is, but it is very good. Is it worth 625? I don't know. It might be worth the Instagram post Going on guys our next Asian concept is Nasli and Cole. We're here with Khadisha. This is a really cool unique concept Tell us about it. Yeah, for sure. So we are a Pakistani and Sri Lankan inspired bakery We are using flavors throughout the entire diaspora in our baked goods Our teas are sourced from small farmers in Sri Lanka and so are our spices. Are you Pakistani or Sri Lankan or Cole? I'm Pakistani, my husband is Sri Lankan. Okay, cool. That's dope collaboration between Daisy countries, right? Can you just break down like some of the items? Absolutely. So this cake right here is a cardamom sponge cardamom You can find in any savory and sweet dish in most Pakistani and Sri Lankan foods But it has a really nice twist with mangoes and raspberries. You've got a carrot-jai cake right here So freshly ground chai spices, carrot chai, with chai. We've got some cannellis We've got Nani's banana bread spiked with cardamom and nutmeg and then our signature cooking. Right here We've got a Camel cake with lavender and wild blueberries as well as some fennel. All right Well, listen guys. We've got to try some stuff here at the Pakistani Sri Lankan bakery. All right you guys, you are looking at a mango Cardamom cake guys, rose syrup, all different types of things here. This is a chai carrot cake Now I was talking to Khadisha. She actually came from a tech background Sort of a very like stereotypical You know upbringing for like a lot of Asian kids going into STEM But you know She was a hobbyist baker and she turned it into a profession now and like we said guys This looks so different from a Galabjuman or a Kulfi But she said that this is incorporating inspirations from Galabjuman Kulfi and all these other Brown, you know daisy desserts into a modern Western cake No That's really good. Eat the flour, bro. Eat the flour. Can you eat the flour? All right guys eat the flour I think there's a dandelion on top. Wow.  Eat the flour man. Let me ask man. I'm not I gotta ask man All right Last but not least we've got this chai carrot cake I think it's so dope because you know online right now You so see so much subtle Asian baking whether it's South Asian or East Asian or Southeast Asian But I haven't personally got to come in contact with that much of the South Asian daisy side. So this is dope You know, I'm not a subject matter expert But I definitely taste a lot of influence from the Pakistani and the Sri Lankan side in these a lot of cardamom Rose syrup, but obviously, you know juxtaposed with a Western cake. It's pretty dope It's almost like Prince tea house, but daisy Prince tea house All right you guys next up on brand new Asian concepts. We have somebody bringing authentic Bami hang street Thai Egg noodles to New York City Andrew. They barely speak English in there. We've got the cracklings on top I heard that this is very difficult to find because this is something you would really get from a street vendor Possibly in the morning or the lunch. You've got ground pork here. You've got chashu right here. You've got the sprouts Bami actually means egg noodle hang means dry. Obviously, this is influenced by a heavy influx of Southern Chinese immigrants primarily Cantonese and Hokkien that went to Bangkok like I want to say at least like a hundred starting about 150 years ago Bami hang very difficult to find in New York City not royal style street food style All right, you guys like we said Bami hang egg noodles dry It's really good I want to say it's missing a little bit of the kick the pungentness that you would get from like, you know A street stall in Bangkok or sword cowboy or whatever, but you know, we're on the streets of fight I right now It's kind of crazy. I see something crazy pop off like we said guys This video is brought to you by Smala www.smala-sauce.com It's out right now from Sichuan, Sicily. It goes perfect on these egg noodles Bami hang. This is actually the first time I've ever had this dish in my life and I'm having it with Smala All right, you guys you guys are looking at one of those like pan Asian dishes You can find this at any Asian fusion spot. I heard you can find it Maybe some version of this in Thailand to tie fried honey chicken fried chicken with the lettuce wrap It's good All right, you guys we are on the border of Soho in West Village right now. I'm here with Quentin You're looking at a French guy who owns a Japanese on a Geary spot Are a lot of people shocked when they see you a little bit at the very beginning? Yeah, for sure But so I come from like a French hospitality background and I wanted to offer something like different Grilled and free and like affordable So that's why we put up Coro Coro in the city right and you guys do a few things different than like a traditional Japanese owner would do right like what are the differences in your guys is on a Geary We fusionate like different kind of cuisine so you can find like some Cuban flavors and Jamaican flavor Sometimes from French flavor to and also you got sort of hot right? Yes, hot and made fresh water as well. All right, you guys a Coral Coral. All right.  They have a Cubano one They didn't have it today. So I got the truffle tuna nice and fresh gluten-free mmm Check it out Ramune Get a Ramune get a on a Geary So upon having this I mean definitely it's a little bit non-traditional So I think if you're looking for a very very traditional on a Geary experience, maybe this is not quite it There's probably another spot. I would recommend in Chinatown called Yaya, but considering there's probably nothing like this on this street I don't know. I got high hopes for it. Let's check out this chicken one Mmm. Oh This one's flavorful Here I got two other flavors I have a sexy shrimp and a yama, which is a green coconut curry And I guess it just begs the question how popular can on a Geary's get in America? They have an emoji for it on your iPhone, but really I mean could it could it keep spreading? I mean it's it's simply just a rice ball with seaweed, but the form factor makes it really easy to eat Let's try the sexy shrimp. Mmm. Not bad. Not bad. Pull them Kind of spicy Yama chicken curry See it right there. Oh Hey, good flavor on all these guys. It's kind of like pizza on a Geary's are a blank slate and fill it with anything I mean, I think it's so cool that you know Japanese cultures at this point where you have all different types of people running a Japanese concept I think the spot is cool And it's just adding something different because honestly you can put anything in rice whether it's a rice bowl or in a on a Geary Rice ball, so I don't know it's exciting and I want to come back and try the jerk The jerk it up flavor and the Cuban flavor because obviously those are the two flavors that I'm like ooh That could be crazy, but anyways guys check it out Korakura West Village All right, our next Asian concept in New York City is actually not Asian It is the second location of a very very famous bakery called Le Cobra. It's actually a Danish bakery Kind of like mixing Scandinavian and Japanese aesthetics together But man, it's not really Asian food, but I just see a lot of Asians here I think Asians really like this bakery particularly this one. I think it might be the design mixed in with that Asians love pastries. I see all types of Asians here other ways South Asian East Asian Okay, I saw these Asian everybody. All right guys So as you can see that there's definitely are some kind of Japanese hints But I think that's because a lot of Scandinavian designs take from Japanese minimalism in Japanese also borrow from Scandinavian Minimalism at the same time So it's kind of hard to tell but there's definitely some Asian accents kind of looking like to Tommy Mads or the or the Paper separators anyways guys. I got the sweet bun here. I feel like this is something that a lot of Asian people would get I'm gonna cut this in half make it look nice Oh Crazy And then here I have the shoe you pronounce it as shoe. This almost looks like the top of a bowl of bow Chinese pineapple bun Dang I might have to try this one first.  I was like, yeah Let me not eat it like a barbarian Oh Not good man mad good My delicious All right, this is some peach cream inside of here Guys doesn't mess it up my my diet I don't know which one I like more men, but I like the circular buns here That's all I can say guys Le Cobra was their second location and a lot of people do mistaken it as a Japanese Concept that's what the worker told me and so yeah, I guess it's not really an Asian concept, but it's sort of


Welcome to Toffy TV, it is the start and 11th show, Everton versus Salford City, Carabao Cwp, second round, Ty, at Gwddersen Park, A15 kickoff, you can watch it on Sky Sports, it is behind closed doors as usual, obviously. Let's get into it, this is the team I think Carlo Ancelotti will play, it's not the team I would play but it's the team I think he'll play so let's go with that. In goal for Everton, I think it will be Jordan Pickford. I don't know whether, because Carlo hasn't done a pre-match press conference so I don't know whether Jonas Larrisle would be available, if he was fit, I'd probably have started him in goal but I think Jordan Pickford will be in goal for Everton. I think right back will be John Joe Kenney, Seamus Coleman played well at Tottenham on Sunday but I think this is the kind of game you give John Joe Kenney. I've got to try and get him some minutes and show what he can do when he'll be hungry to do well so John Joe Kenney right back, left back Luca Dean. I had thought of Niels and Kungku but I think he'd probably be on the bench so I think the Ancelotti will go with Luca Dean at left back and the two centre backs, I'm going to go with Michael Keane and Jared Branthwaite. Obviously the main two centre backs are Keane and Meenner at the moment while Mason Holgate is out but they've Yeri Meenner on the bench for this one so Jared Branthwaite obviously he's played at league two level, he's played in the Premier League as well so get him alongside Michael Keane. Then into midfield I think the manager will play Tom Davis in the six, I think Guilfee Sigarton will play in midfield as well and I think he will use Alex Awobi in there as well so I think that'll be a midfield three and then I think there'll be three ahead of that and I'm going to go with Bernard on the left, it might be Awobi on the left and Bernard in the middle but I'm going to go Bernard on the left. Theo Walcott I think will start on the right hand side and I think Moise Keane will be up front for Everton. I think he'll adopt a similar formation what he used to Tottenham on Sunday. Me personally if I was just picking it I think I'd be tempted to play Alan and the Corey but I can understand him maybe giving him this game out and trying to just make sure they're ready for what is a big game at the weekend against West Brom and Albin so I think he's got to try to get some players some minutes also maybe a shot window possibly for a couple of them who knows and then on the bench obviously he'd probably keep Richard Wallace and maybe Dominic Halvitt-Lewin, Anthony Gordon I'm sure he'll be on there, maybe Yannick Bellasio he'll be on there and maybe one of Alan or the Corey might be sure. I don't think Hames will be in the 18 he might well be but I don't know whether he'd just be rested now till Saturday but that is the team I think Carlo Montialotti will pick. Let me know in the comments section below what you would go with. Would you wrap Alan, the Corey and Hames in Cottonwall ahead of a big game against West Brom and Albin at the weekend or would you play them in this one? Some people have seen saying play as strong as the 11. I think we will make changes because I think he will look at it and go these are in our squad and if these players aren't good enough to beat a mid table league two side without being disrespectful to Salford City that's what they are at the moment. Then they shouldn't be in our squad so it's a chance for people to get in and put a marker down to the man and didn't say look you know why he's here to be in the squad. If they get in and don't perform then there's not a damn for them really so that's the way I see it ahead of Salford City. Let me know in the comments section below. Make sure you subscribe give the video a thumbs up and if you want more videos join us on Patreon. See you later.


Hey guys, welcome to SSunitech Social Decide and today we are going to see about the asset transformation in the SEO data factory. I would strongly recommend to watch this complete video because here we are going to see the real-time use of the asset transformation and this I have already implemented in multiple projects. So what is asset transformation? The asset transformation enables you to build custom rules inside your mapping data flow for data quality and data validation. So for example, if we are getting the data from the source, so before going to load that into the destination, we are required to check whether the data is the correct or not. If data is not correct, then we are required to load that into some error file or the error table inside the SQL server and the correct data will be loaded into the destination. You can build the rule that will determine whether value meet an expected value domain. Additionally, you can build rules that check the row uniqueness. So this is the first property that we can check whether the values are having the duplicate data or not. If we have the duplicate data, then we can mark that data as incorrect data. Next, the asset transformation will help to determine if each row in your data meets a set of criteria. The asset transformation also allows you to set the custom error message when data validation rules are not met. So basically here we can do the testing of your data by three ways. First is the expect true, second is the expect unique and third is the expect exist. So what all these three? Let's go to the source and we'll try to see there in the practical. So here we are having this source which is the sales data and we can see it has total six columns with the sales order ID, sales order date, customer ID, quantity, value and country. So here first we can see inside the sales order ID, we have the duplicate data for the ID 9. So this is the error rows. So we are not required to load that into the destination. Next, if we can see under the sales order date for the ID 4 and 5, then we can see this is not the correct date. Month 15 is not available for the row 4 and similarly for the 16. So these two rows are incorrect data. So this is for the expect meets and for the expect uniqueness that will be the ID 9. So these two are failing the condition and third one that we have seen in the slide which is the expect exist. So this option is only available when you have selected a second incoming stream. So that we will see in the practical. Don't worry for now. Exist will look at both stream and determine if the row exists in both streams based on the column or the expression that you have specified to add the second stream for the exist. We can select the additional stream that we will see. Don't worry for now. So once we will select that option, then here we can see we are having another file which is the customer detail dot CSV file. So as here we could see it has total two columns with the customer ID and the customer name. So as here we can see it has only ID 1, 2, 3 and 4. If we can go in the sales data here we can see it is having the ID 5 as well that we can see in the sales order 6. So ID 5 is not available in the customer detail. So this is also going to mark as the error row and we are not going to load that into the destination. So total we have three conditions. So we will be implementing that later bit. So before that, so let me go in the SSMS and we'll try to see the sync. So here as we could see we are having these two tables. First is the sales table and second is the sales error data. So these two tables let me execute. So as of now we don't have any data here but we can see it is having total six columns that we have seen in the source for the sales data which is the correct data. For the error records here we have one additional column and this additional column is indicating like on which column we have the error and what is the error data. So everything will be available on this error column. So let me try to implement this in practical. So here let me go in the Azure Data Factory and let me try to add a new data flow and here let me try to add the sales source here. So let me click on this and after that we need to select the data set. So as I have already created the data set for the same, so let me try to use that one. So this is having the same data as we have seen there. So let me enable the data flow debug option here. So we will see that. So now we can click on refresh. So it will be going to load the data. So now we can see all the data here. Let me quickly go in the source and let me click on this plus symbol. So here we are required to add the asset transformation. So the asset transformation is available under the row modifier. So let me click on that. Now so here we can see the output stream name. So that will be the asset one that is okay. Incoming is the source one that is also okay. Here we can see the additional stream. So this is the additional stream that we are talking about. So the additional stream in this case will be the customer data. So that we will be going to add later bit. So in the downside here we can see the option for the asset and here the asset type. So under this asset type we can see total two values here as of now. First is the true and second is the for unique. So let me try to use the unique first and here we are checking the sales order ID as unique values. So here we can see the expression. So under this expression we need to select the column by which we want to check the uniqueness. So we want to check the uniqueness on this sales order ID. So we can select that one. Let me go in the data preview and here we will be going to see whether the duplicate row which is the ID9 is marking as error records or not. So that will be going to visible here. If you can scroll down here then here we can see the notification for the error records. So these two are going to mark as the error records because here we are having the duplicate values for the ID9. Now go to the asset setting again. Let me try to click on this add and this time we want to check the dates. So as we have checked for the uniqueness second we need to check for the dates whether the sales order date values are correct or not. So for that we are required to select the expect true and here we can call this as sales order date. Here we can add the description of this asset. So this is optional and for filter here we can also do the filter if we want to check this for any specific column value. So for example if we want to check for the country India then we can add the filter here. So we are going to check for entire data. So that's why I'm not going to use here anything. Now let me go on this expression and open the expression builder. So under this expression builder here what we need to do first we are required to convert this into the date. So we have to use the true date for converting this here we need to specify the string value. So that will be your column then we can see the date format. So the date format that will be dd mm yy. So it is going to convert this into the date. So we need to check whether this is converted properly or not. Once this is going to convert properly then it will be going to return the none. If it's not going to return properly then it will return not none value. So let me use the is null function to check whether this is returning true or not. So this time if this value is correct data. So if your sales order data is correct then it will be null. So here we are checking for the is null. So it will always return as true. So if it is returning true then your output value will be false. So we have to reverse this. So it should be not equals to if this value is not null then that will be the error records. So we have to use this like not equals to is null and this date. Now let me click save and finish. Let me go into the data preview and try to refresh it. So here we should be going to see the output of this incorrect data will be error records. So here we can see like for ID 4 and 5 we are getting the error records. So now we have total 4 records which is the error records. Here we need to do for the existing for the customer ID. So for that we have to add the another source. So let me try to add the another source and this source too is for customer data. So I am going to call this as custom. Here let me try to add a new source go to the Azure Blob Stories click on continue delimited text click on continue. Let me call this dataset as customer link service we can select then we need to select the file so we can browse it and under this we can go into the input folder and here we need to select the customer file so customer detail.csv file we can select and click on okay. Now the first row is header so we need to mark this as true. Now let me click on okay. So here we have created the dataset for customer. So everything is okay. Let me go back to the asset transformation and here under this setting we can see the additional stream. So this additional stream is our label now which is the customer that we have created we can select it. Now here we can add one more asset and this asset will be for expect exist. So we can select that one and let me call this for the customer and here we need to check if the customer ID from the source one is equals to the customer ID from the source two so that we can see the customer ID from this so if this is going to match then we are going to mark that value as true. If it's not going to match then those records will be going to mark as error records. Let me go in the data preview and try to refresh so we can verify that so here as we could see ID 456 and 99 so these are the error records. So now what we are required to do here if we will be going to have one more column and that column will be going to hold the value for the error description then we can directly load and filter this data. So how we can do that so for that we have to add the derived column transformation here so we can add this one and after that here we can see the columns so we want to add a column so let me call this like error rows so here we need to use two functions so let me try to open this expression builder first function is is error so what is error will do is error will be going to return the error rows if that value is error rows then it will be written true if we have the correct value then it will be written false so let me click on save and finish let me go in the data preview and try to refresh it so here we will be going to have an additional column and that column is having true or false if error record then that is true if not then that will be false so here as we could see this error records here it is false false false here we can see true because the ID 456 all three are having the error records so we can see the true similarly for ID 9 as well but this is not going to fulfill our complete requirement because here we are going to use this error rows to filter out the data for the error records as well as for the correct records but we want to keep the description as well like on which column we have the problem we have to use the another function so let me go here in the derived column and let me try to add one more column on this column settings by clicking on this plus symbol with add column and this let me call this as error description here we have to use has error function and we need to specify the string so what will be the string value here let me cancel this and go back to the sr transformation so under this sr transformation we have seen like we have created these three values so the description we have to specify the sr id so these sr id is going to indicate whether the problem is on that column or not so for example let me try to copy this s oid from here go to the derived column go to the expression here and under the expression let me use the has error and here we have to specify the s oid whenever we will be going to have the problem with this assert then that record will be true and other records will be false let me save and finish and we will try to verify the same so now we will be going to have two additional columns one for the error rows and second for the error on the s oid so here we can see the error description so we don't have the problem with the s oid on these three columns so that's why we can see the false on the error description here we have the problem on the s oid so that's why we can see true here so we need to write some expression to modify this true value with the proper column name so how we can do that let me go in the derived column setting go to the expression again so here we have to check the multiple condition so I am going to use the case statement here so we can write the case if this value is equals to true then the problem which is on the s oid column we can close the bracket so what it is indicating it is indicating if the problem with the s oid then it will written s oid on that error description column similarly let me try to check for the another assert so if the problem with the s oid then we can check if the value is true then we can call this as s oid so it will have the problem with the s oid column here we can put the comma because we are specifying the another condition similarly let me add the last condition and this last condition is on the customer so we can call this as cussed now we need to check whether this value is true or not if this value is true then we can call the problem with the customer id column so this is we have to specify on the error description so what it is doing it is checking if the assert value of this s oid is false then that will be the correct record if the assert value of this s oid is true then we have the problem with the s oid similarly for s oid and the customer let me try to save and finish let me go on the data preview and try to refresh so we can verify the data so here we will see the column value will be updated from true or false to the proper column names which is causing the problem so here as we can see so the customer id is showing here and the s oid is showing here but here the problem like on the date it is not showing properly because if you can go in the asset transformation again here we can see the s o date let me copy this so this is the case sensitive so we have to use as it is as we have used inside the asset transformation so if you can see we have used s o date but d is not in capital so that is why it was not reflecting there let me go in the data preview and try to refresh so we can verify the data there so here as we can see the error description is updated properly now we want to load the correct data into the proper destination sales table and error records in the error table so how we can do that so first we have to do the filter for the correct record and incorrect records so let me try to add the filter transformation here and the filter transformation we have already discussed so if you haven't watched that video so I will try to provide the link of that video in the description of that in this video so you can watch from there so here we have to check if the column which we have created the error description one or the error row if the error row value is false then we want to load all the data into the correct destination so we can also call this like correct data now here let me try to add the sync so this sync will be the sequence of a table as we have already created so let me try to create a new data set here let me search for azure sql database let me click on continue link service we have already created and let me call this as sales for azure sql here we can select this sales table now let me click on okay so we have selected and created the data set but we need to go in the mapping instead of the auto mapping let me disable that here so id second will be the so date then we have the customer id so we can select the customer id from here next we have the quantity so quantity should be here so we can select the quantity similarly we have value so value that should be coming from here in the source so we can select that so everything is done now we can go into the data preview of this so here we have some problem with this correct data because it is not expecting the space in between correct and data let me go in the sync and try to refresh it so here we should be able to see the correct data only because we are trying to load that data so here as we could see we are having only these five rows because these are the correct data next how we can use the incorrect data to upload into the table so for that after this derived column we are required to use the new branch so we can click on this plus and new branch transformation is here so it is going to create the duplicate copy of this derived column transformation after that we can add the filter again so this time your filter will be like error data that we have created column so here we can see the false so let me go over here here we need to add the condition so here let me try to use the column which we have created the error row if this error row value is true let me click save and finish so those records will be filtered by using this filter one and let me click on this plus symbol and it will be loading into the destination as well so here in the destination let me create the dataset for the same and the dataset that should be as your SQL database we can click on continue let me go here and here let me select the table for the error row and here let me call this dataset as sales error let me click on okay so this dataset will be created now we can go into the mapping instead of auto mapping we want to map this manually so first is the SOID second is the SO date third is the customer ID fourth is the quantity fifth is the value and the last which is the error column so let me use the error column that we have created like error description so everything is matched here now let me go into the data preview and try to refresh it so this time we should be able to see only the error records with the proper error description so as here we could see it is having all the data like this and here we can see the error records on these columns as well now let me try to publish all these which we have done here and let me go into the pipeline and we'll try to add a new pipeline to execute this so let me try to use the data flow transformation to execute the data flow that we have created so here let me go on the setting and I have to select the data flow one now we can try to debug it so once it will be executed your destination table will have the data for the sales and error records so it got executed successfully let me go into the ssms and here let me try to check whether data is inserted there or not let me try to click on this execute so here we can see under the sales data we have total five rows those are having the correct data and under this we are having again the five rows those are having the incorrect data like first two rows is having the problem with the sales order id here next two rows we can see the problem with the sales order date and the last which is the customer id so this is having the proper error description here so we can identify and we'll try to correct it and we'll be loading again so thank you so much for watching this video see you in the next video


Hello and welcome to this presentation of the STM32i²C interface. It covers the main features of this communication interface, which is widely used to connect devices such as microcontrollers, sensors, and serial interface memories. The i²C interface is compliant with the NXPi²C bus specification and user manual, Revision 3. The SM bus system management bus specification, Revision 2, and the PM bus power management system protocol specification, Revision 1.1. This peripheral provides an easy-to-use interface with very simple software programming and full timing flexibility. Additionally, the i²C peripheral is functional in low-power stop modes. The i²C peripheral supports multi-master and slave modes. The i²C iO pins must be configured in open drain mode. The logic high level is driven by an external pull-up. The i²C alternate functions are available on iO pins supplied by VDD, which can be from 1.71 to 3.6 volts, and on iO pins supplied by VDD iO2, which can be from 1.08 to 3.6 volts. This allows communication with external chips at voltages different from the STM32L4 main power supply. A typical use case is communication with an application processor in sensor hub applications. The iO pins support the 20 milliamp output drive required for fast mode plus. The peripheral controls all i²C bus-specific sequencing, protocol, arbitration, and timing values. 7 and 10-bit addressing modes are supported, and multiple 7-bit addresses can be supported in the same application. The peripheral supports slave clock stretching, and clock stretching from slave can be disabled by software. The setup and hold times are programmable by software. Analog and digital glitch filters on the data and clock lines can be configured by software. The peripheral can wake up the MCU from stop mode when an address match is detected. The peripheral has an independent clock domain, which allows a communication baud rate independent from the system clock. Here is the i²C block diagram. The registers are accessed through the APB bus, and the peripheral is clocked with the i²C clock, which is independent from the APB clock. The i²C clock can be selected between the system clock, APB clock, and the high-speed internal 16 MHz RC oscillator. Analog and digital noise filters are present on the SCL and SDA lines. A 20 mA driving capability is enabled using the control bits in the system configuration registers. In addition, an SM bus alert pin is available in SM bus mode. The STM32L4 embeds noise filters on i²C data and clock lines. The analog noise filters can filter spikes up to 50 nanoseconds and can be enabled or disabled by software. By default, analog noise filters are enabled. The digital noise filters can be enabled on the SDA and SCL lines instead of the analog noise filters. These filters suppress spikes with a programmable length from 1 to 15 i²C clock periods. The digital filters offer an extra filtering capability compared to the 50 nanosecond required by the i²C standard. The digital filter value is fixed by software, while the analog filter value may vary with process, temperature, and voltage. Take care that the digital filter is disabled by hardware when the wake-up-from-stop feature is enabled. In this case, only the analog filter can be enabled. The i²C setup and hold times can be configured by software through the i²C timing register. The SDA-DEL and SCL-DEL counters are used during transmission in order to guarantee the minimum data hold and data setup times. The i²C peripheral waits for the programmed data hold time after detecting a falling edge on the clock line before sending the data. After the data is sent, the clock line is stretched low during the programmed data setup time. The total data hold time is greater than the programmed SDA-DEL counter. This is due to the fact that SDA-DEL delay is only added once the SCL falling edge is internally detected. The time T-sync one needed for this internal detection depends on the SCL falling edge, the input delay due to the filters, and the delay due to the internal SCL synchronization with the i²C clock. However, the setup time is not impacted by these internal delays. The i²C master clocks, low and high level durations are configured by software in the i²C timings register. The SCL low and high level counters start after the detection of the edge of the SCL line. This implementation allows the peripheral to support the master clock synchronization mechanism in a multi-master environment as well as the slave clock stretching feature. Therefore, the total SCL period is greater than the sum of the counters. This is linked to the added delays due to the internal detection of the SCL line edge. These delays, T-sync one and T-sync two depend on the SCL falling or rising edge, the input delay due to the filters, and the delay due to the internal SCL synchronization with the i²C clock. The i²C slave can acknowledge several slave addresses. The slave addresses are programmed into two registers. Own address register one can be programmed with a seven or a ten-bit address. Own address register two can be programmed with a seven-bit address, but the least significant bits of this address can be masked through the OA2-MSK register in order to acknowledge multiple slave addresses. The two own address registers can be enabled simultaneously. The i²C peripheral supports wake-up from stop mode on address matches. To do this, the i²C peripheral clock must be set to the high-speed internal 16 MHz RC oscillator. Only the analog noise filter is supported when the wake-up from stop feature is enabled. All addressing modes are supported. When the device is in stop mode, the high-speed internal oscillator is switched off. When a start condition is detected, the i²C peripheral enables the high-speed internal oscillator, which is used to receive the address on the buzz. After an address is received in stop mode, a wake-up interrupt is generated if the address matches the programmed slave address. If the address does not match, the high-speed internal oscillator is switched off, no interrupt is generated, and the device remains in stop mode. Clock stretching must be enabled because the i²C peripheral stretches the clock line low after the start condition, until the high-speed internal oscillator is started. After having received an address that matches the programmed slave address, the i²C peripheral also stretches the clock line low until the STM32L4 device is woken up. Master mode software management is very simple. Only one right action is needed to handle a master transfer with a payload smaller than 255 bytes. The full protocol is managed by the hardware. In order to start a transfer in master mode, i²C control register 2 must be written with the start condition request, the slave address, the transfer direction, the number of bytes to be transferred, and the end of transfer mode. End of transfer mode is configured by the auto-end bit. If it is set, the stop condition is automatically sent after the programmed number of bytes is transferred. If the auto-end bit is not set, the end of transfer is managed by software. After the programmed number of bytes is transferred, the transfer complete, or TC flag, is set, and an interrupt is generated, if enabled. Then a repeated start or a stop condition can be requested by software. The data transfer can be managed by interrupts or by the DMA. When the payload is greater than 255 bytes, the reload bit must be set in i²C control register 2. In this case, the transfer complete reload, or TCR flag, is set after the programmed number of bytes has been transferred. The additional number of bytes to be transferred is programmed when the TCR bit is set, and then the data transfer will resume. The i²C clock is stretched low as long as TCR is set. The reload bit is used in master mode when the payload is greater than 255 bytes, and in slave mode when slave byte control is enabled. When the reload bit is set, the auto-end bit has no effect. By default, the i²C slave uses clock stretching. The clock stretching feature can be disabled by default. In reception, the slave acknowledge on received byte behavior can be configured when slave byte control mode is selected together with the reload bit being set. When the SBC bit is set, the number of bytes counter is enabled in slave mode. Clock stretching must be enabled when slave byte control is enabled. In reception, when slave byte control is enabled with the reload bit set and the number of bytes to be transferred is 1, the transfer complete reload flag is set after each received byte and SCL is stretched. This is done after data reception and before the acknowledge pulse. The receive buffer not empty flag is also set so the data can be read. In the TCR subroutine, an acknowledge or not acknowledge can be programmed to be sent after the byte is received. It is recommended to clear the SBC byte in transmission, as there is no use for the byte counter in I2C slave transmitter mode. In SMBus mode, slave byte control mode is used in transmission for sending the PEC or packet error code byte. The I2C peripheral provides hardware support for SMBus. The SMBus address resolution protocol is supported through the device default address and arbitration in slave mode. The host notify protocol is supported with host address support. The alert protocol is supported through the SMBus alert pin and alert response address. The SMBus clock low timeout and cumulative clock low extend times can be detected with a programmable duration. The bus idle condition can be detected with a programmable duration. Command and data acknowledge control is supported through slave byte control mode. The packet error code or PEC byte is calculated by hardware. The packet error code or PEC byte is automatically sent in transmission and checked in reception. The data transfer counter initialized with the N bytes value is used to automatically check the PEC byte in reception after N bytes minus 1 byte are received. If the received PEC byte does not match the calculation, a not acknowledge is automatically sent after the PEC byte. In transmission, the internally calculated PEC byte is automatically sent after the N bytes minus 1 byte. Slave byte control mode must be enabled in slave mode in order to enable the N bytes counter and allow automatic PEC reception or transmission. Several events can trigger and interrupt. The received buffer not empty flag is set when the received buffer contains received data and is ready to be read. The transmit buffer interrupt status is set when the transmit buffer is empty and is ready to be written. The stop detection flag is set when a stop condition is detected on the bus. The transfer complete reload flag is set when the reload bit is set and N bytes byte of data have been transferred. The transfer complete flag is set when the reload and auto end bits are cleared and N bytes bytes of data have been transferred. The address match flag is set when the received slave address matches one of the enabled slave addresses. The NAC reception flag is set when a not acknowledged is received after a byte transmission. DMA requests can be generated when the received buffer not empty or transmit buffer empty flag is set. Several error flags can be generated. A bus error detection flag is set when a misplaced start or stop condition is detected. The arbitration loss flag is set in the event of an arbitration loss. An overrun or underrun error flag is set in slave mode with clock stretching disabled when an overrun or an underrun error is detected. In SM bus mode, a PEC error flag is set when the received PEC does not match the calculated PEC register content. A timeout error flag is set when a timeout or extended clock timeout is detected. An alert pin detection flag is set in the SM bus host configuration when alert is enabled and a falling edge is detected on the SMBA pin. The I2C peripheral is active in run, low power run, sleep, and low power sleep modes. I2C interrupts cause the device to exit sleep or low power sleep modes. Address detection is active in stop modes. The I2C peripheral generates a wake-up interrupt in the event of an address match. In standby and shutdown modes, I2C is triggered down and must be re-initialized after exiting standby or shutdown mode. For each I2C peripheral, a bit is available for debugging purposes in the MCU debug component that can be used to stop the SM bus timeout counter when the core is halted. Here is an example of a sensor hub application that requires several I2C peripherals. One or several I2C masters are used to interface with external sensors. It is possible to configure the STM32L4 device in low power sleep mode for this purpose in order to reduce power consumption during data transfers. This is called batch acquisition mode. Only the required communication peripheral, plus 1DMA, plus SRAM1 or SRAM2 are configured with the clock enabled in low power sleep mode. The flash memory is put in power down mode and the flash clock is gated off during low power sleep mode. The I2C clock can be at 16 MHz even in low power sleep mode, allowing support for the 1 MHz fast mode plus. An I2C slave is used to communicate with the application processor. The STM32L4 device can be put in stop mode and wakes up only when addressed by the application processor. The STM32L4 devices embed up to four I2C peripherals with this full set of features. Wake Up from stop 1 mode is supported by all I2C instances. Wake Up from stop 2 mode is supported only by I2C3. For more information related to this peripheral, you can also refer to these peripheral trainings. System configuration controller, reset and clock controller, power controller, interrupts controller, and direct memory access controller. For more details, please refer to the I2C bus specification and user manual from the NXPE website. The SMBus specification can be found in the Smart Battery System Implementers Forum. The PMBus Power System Management Protocol specification can be found in the Power Management Bus Implementers Forum.


What is up guys karma medic here and welcome back to another dose in this video Me and Ali have sat down and answered a whole bunch of questions that you guys sent over to us on Instagram This is actually the second part of a two-part video The first part is up on Ali's channel so make sure you guys click and watch that after this is done Okay, next question from Mohammed underscores saw us. How did you find each other in reality? That was a good hat Yeah, I am actually No, Ali's been absolutely great with me today We went out for lunch with a couple of his friends and it's been a pleasure. Yeah, man I wanted to do collab with you for a while and true when we haven't been able to make this happen for quite some time We wanted to do a pre-covid.  I'm free this weekend. Do you want to come down? Yeah, we're just chilling. Yeah, I'm gonna get time. It's been great all that stuff question from Bonnello underscore m underscore Tips for someone who's camera shy, but wants to start a YouTube channel I feel like you're gonna say something nice and I'm gonna say something mean the meaning I'm gonna say something nice Every everyone thinks that their camera shy camera being camera shy is a natural state of affairs No one is born being able to look at a camera and talk to it and like rant at it If you want to start a YouTube channel But you think you're camera shy Recognize that this is a skill and like everything else in life is a skill that you can work on and get better at I hated talking to a camera for the first few months of being on YouTube I'm sure you did as well like this. It's it's not a thing you just get better at it And it is possible to make a successful YouTube channel without showing your face True.  Yeah, and like be everyone's people like when Wendover Productions codes Versace CDP grade they don't show their faces But it's really really hard to get to that level where you're so pro where the content and the story and tells it Informational is so good that you don't need to show your face. That's true. It's so hard to do I wouldn't recommend it. I was gonna say something very similar to you I think that was great advice like everyone when they pick up a camera are camera shy and I'm camera shy till this day I still need a little bit of time to warm up to it So it is like you said recognize that it's a skill like anything else You can learn to speak more eloquently in front of a camera and go back to any of our earlier videos Like you will notice how differently we speak to a camera. Hi. My name is Nasser Karma I'm 22 years old and I want to start making YouTube videos. Hey YouTube, how's it going? I'm back for video number two on my channel video number three video number four. What's up guys karma medic here? Welcome back to another dose. So it's something that you get over with time same with vlogging in public practice practice practice Yeah, it's still a challenge. I'm sweating enough just doing this if this were in public. Oh god This is a fun question from a Bruno Wigelius. How is having multiple income streams impacted your lives as medical students? So for me, it's just enabled me to make purchases that I otherwise would have never done before Like for example yesterday, I bought this Apple watch series six. Oh, nice. I've still got a series four man. All right Yeah, you must be boring So like this literally came out a couple of days ago and I didn't even have to think that hard about it I was like, this is something that I think will be beneficial in my life. I could make some videos on it I want to get it and so I did whereas before like I would have never even considered getting an Apple watch It's not a necessity in my life It's not something that I need in order to be productive or anything like that So yeah, it's enabled me to make decisions like that The other cool thing is that so in in my case a lot of the purchases that I can make Are business expenses so cameras microphones lights laptop screen like almost every piece of tech I buy is as a business expense And when you have it as a business expense, you essentially don't pay tax on it like three times over and so you kind of get at half price I've got a video talking about this more in depth coming out at some point I think yeah having that business and having that business make money It's just like so helpful because like, you know, like you said if like a new iPad comes out I will just buy it no questions asked and that's you know, a really fortunate and privileged position to be in Which is what you get when you start a business and have multiple streams of income And you can get there by following my video about how to make money online three levels of LinkedIn the video description and up there Plug emoji plug emoji. All right We've got a question from Iqra Hussain who says do you ever have days where you just a CBA laugh emoji? I think I have parts of days where I just CBA Generally when I wake up in the morning I like we'll get out of bed because I'm already thinking about what the first thing I want to do is after breakfast And so I generally just start doing things that are on my to-do list I do have times where I CBA and then I'll just sit down and watch some youtube videos or like Go procrastinate and talk to my sister or whatever, but full days where I CBA. I think it's pretty rare for me Yeah, same for me Like I think when when you're a beginner to the productivity thing you have to really decouple What you feel like doing from what you're actually doing Because what you're going to feel like doing is just watching Netflix all day or something stupid like that And if you want to start a youtube channel, it'll be consistent and start a business with anything You need to use discipline to overcome that barrier between The thing I feel like doing is not the thing that I know I should be doing for me now I'm at the point where actually if I just do what I feel like doing at any given moment Things are probably going to be all right and it is something productive probably anyway Yeah, it probably is like occasionally I'll sit on the on the couch and just scroll through instagram completely unproductively or tiktok or tiktok In your case in your case. Yeah If you're working on something that you really enjoy like These youtube channels that we're working on then it doesn't really feel like work doesn't feel like a chore It doesn't feel like effort. It's something that I want to do anyway And yeah, maybe I'm not bothered at this specific time, but then I'll just tell myself Okay, fine. I'll take a break for an hour and then I will do it and then it gets done after that All right, we've got a cool question from linky h2z z or something like that who says how do I gain confidence? I'm third year and feeling like I know nothing can't diagnose and feeling insecure Okay, so I guess there's kind of two strands There's confidence generally and there's like domain specific confidence confidence specifically So in any field whether that's medicine or law or anything for me The only way I can see myself overcoming a weakness or not being confident in something is by practicing that exact thing That I'm not good at or researching how I can become better at it Especially in medical school the times when I've learned the most and grown the most is when I've been put in a really uncomfortable situation When I really didn't want to take that history or I really didn't want to practice this clinical skill But I was told to and I was like, okay, it's time to actually do this now That's when I learned the most and I think don't be scared of failure A lot I think a lot of people put too much emphasis on failure If I ever fail at something or if I do bad at something like that's completely okay I'm I'm fine with not being good at things. Everyone is not good at things And I think it's like what you take from that experience and how you move forward, which is important as opposed to the act of failing Everyone fails multiple times a day. It's completely fine. And I don't think we should put so much emphasis on it Yeah, absolutely There's a nice phrase that competence breeds confidence You can't be confident at like surgery unless you're competent at surgery And you shouldn't try and be confident in surgery unless you're competent at it So work on the skill first and over time you'll become more confident I think also there is a school of thought because like when when I was in school I wasn't very confident at all and I kind of read a lot of books about this and watched a lot of videos and stuff about How to become more confident Okay And I came across a book which was called like the wrongless approach It was written by this like magician hypnotist pickpocket kind of performer guy And he was talking about how to become more confident and doing bossy things like going up to someone like Stealing their watch without them noticing stuff like that that requires a large degree of confidence Let's put your hands away Require a large degree of confidence And he was saying that the thing that changed it for him Is that you realize that that there's no real difference between real confidence and fake confidence Instead of treating confidence as like this a sort of magical power that we have to acquire over time You can just choose one day to flip your mind into thinking that okay I'm a confident person and I'm going to pretend to act as a confident person would And no one else from the outside would be able to tell that you're faking confidence As opposed to you're actually confident And so certainly when I'm on camera, I certainly I I I hope that I look that I'm confident But I am faking it. I'm pretending to be I'm pretending to act like a confident person would and no one can tell the difference And that's the thing with like Generalized confidence versus specific confidence. I think specific confidence Domain specific confidence is built on a background of competence But general confidence is a skill that you can just choose It's like it's like a mindset that you can choose to embody if you want do you disagree I don't think I disagree I just think that's probably hard for a lot of people who aren't confident to sort of flip that switch I mean even for me like when I'm putting uncomfortable situations in a group of people who I don't know, for example Like I am naturally more nervous and my voice will crack more than it normally does And as much as I pretend that I am confident, it doesn't always work I think for me again, it just comes down to exposure But obviously there's so many different ways that people overcome these types of things Um, but for me exposure sort of triumph triumphs everything So we've got a question here from Akshai Singh 6253 and they ask how to grow your audience I think I think we think very similar things with this because I've heard you talk about this and I could not possibly agree more I think at the very beginning especially when I started making videos No one cares about who nasa is nobody even knows who nasa is The only thing people care about is that you're telling them something of value You're giving them some point that they can take away that they can write down that can help improve their life in some way shape or form And so all my beginning videos were trying to give out information trying to give value to the people who are watching And even though I wanted to do more vlog type content lifestyle type content I always told myself nobody cares right now because no one knows who I am No one knows about my personality what I do like what I don't like And so there wasn't really as much of a point making those videos Because why would somebody watch that about me if they don't know who I am first provide the value Gain your audience from that and then you can start to experiment in different streams Yeah, man value lead with value people don't care about you They care about the value you give to them and so the way to grow your audience is by just giving them loads and loads of value Doing it for free. I've got this like three pot formula. I'm gonna make a video about this It's like build your audience number one take notes provide value number two Do it for free once a week and three do it for two years If you can do that if you can actually do all those things create valuable content Put it out for free once a week and do it for two years You will have an audience you're basically guaranteed to do it It's just that no one who asked that question who like actually does the does all three of those things I completely I completely agree The biggest thing I think is people can't do it for two years. Like I just reached the point now I was looking at my analytics yesterday and For half the time my youtube channel has existed I have had nobody watching my videos like 50 to 100 people watching for half the time My channel has existed and then the second half is what you guys are used to and what you guys are seeing I guess So it takes a long time for people to find you people to become accustomed to you people to like you people to share your stuff And the difficulty is sticking through it for that long period of time And I feel like that's where most people fail if you do stick with it I genuinely think you're guaranteed to have an audience you're guaranteed to have people who care about you There's enough people who watch these videos enough people who share them and they have friends and they tell their friends Like it's bound to happen. Just given enough time Okay, so we've got a question from a zack highly who says do you have a 10 year plan? So a short answer to that is no, I don't have a 10 year plan. I don't even really have a five year plan I think uh barely have a one year plan. Yeah, no, exactly like Um, I think like the future is so uncertain like, you know For us like two years ago like a year ago We wouldn't like neither of us would have had any idea about the impact that our youtube channels would have on our lives And how kind of change things moving forward every everything changes so rapidly that to have any kind of plan It just seems to me to be a bit of a waste of time I get that some people say that it is useful to do the exercise anyway just because then you really figure out what what do you actually want and Try and imagine what you'll feel like when you get there and stuff So maybe there's value in it But at the moment I haven't really done the 10 year planning extensively I very much agree with what you said and I think like having goals is something that's obviously very important But I talked about this in one of the recent videos I posted about how I studied so long for six months for the step one exam And the last thing I said in that video was that I try and always focus on what's directly in front of me And I don't think too far ahead. I don't try and over complicate things because then it's just it's overwhelming And it's stressful the more I can focus on what's directly in front of me the better of a job I can do at that So I have goals that I want to achieve in life But they're sort of these vague big things that I'm going to eventually reach in the future If I just keep up doing what I'm doing What are the goals you want to achieve in life? Want to become a doctor okay first and foremost You know have a family like all the standard things. I don't really have anything like out there Yeah far enough kind of the same for me except I want to become a gymshark athlete True. You're on your way there. You're not wearing this t-shirt though You've got to wrap the brand Question from YNO Pilapil says best collab exclamation mark What do you think you both have in common that led to your success? One of the things that we have in common is that we're willing to put in the work Over long periods of time even if it isn't something that is easy Or something that's beneficial right now, but we know that it could be in the future I think where a lot of people might get bored or give up or lose faith We would be willing to push through that. Yeah, I think the consistency is definitely a big part of it I think also like the formula for success is sort of putting in a hard work But then multiplying it by unfair advantages certainly the unfair advantage that we both have is that we're both medics That is Immediately an unfair advantage because there are so many medical students medical applicants looking for medical content The other unfair advantage is that we're both a certain level of privileged whereby we could have just decided that You know, I want to start a youtube channel. It wasn't the case that I imagined for you we had to sort of work a Sort of a job in like a shop or something like some of my friends had to do during the summer to make ends meet that kind of thing We were like sufficiently privileged to be able to put in the graph for two years While not really getting much success and continue to kind of plug away at it So I think there are those unfair advantages Some people would say we're both guys we're both reasonably well spoken Like all of these things are complete complete accidents that we had nothing to do with that come together nicely to give There's a package of unfair advantages and then you just multiply that with hard work and consistency and stuff And then that's the formula and then sprinkle in some luck sprinkle in some luck exactly Yeah, that's such a huge part in it like right place right time. Yeah, especially with the videos doing well We're like going big exactly like there's no way to predict a certain video going big But it's like the end that there's a thing that Gary V says which is that it just takes one piece of content to change your life You just never know which one that's going to be that's a good quote And so, you know, I was plugging away videos It it took me like I don't know 70 videos to get to a few a few thousand subscribers You probably got a lot sooner took me a year and a bit before my first video took off Oh, okay. What was that video that took off? It was a medical school vlog final Oh, yeah It did it did I have no idea Some of my videos have changed my life You know the ones that that like have zillions of hours of research to go into them might not might do as well Your how to type fast video. Yeah, absolutely. Yeah like for the first few days It was on six out of ten on the analytics I was thinking.  You never know? dose of luck. But then just keep on doing what you're doing. The more videos you plug out, the luckier you get. All right, so we've got a question from Hott, who says podcast that you would recommend for young entrepreneurs. Oh, this is a good one. Seems like it's right up your alley. Right on my alley. Yeah. I'll be listening as well. This is a good question for me. Okay, I'd recommend the Indie Hackers podcast. This is a podcast where they interview independent creators who have set up internet businesses that are making money. Usually they talk about revenue figures as well, which I always like that, for example, this is the story of how this dude who's 16 years old from, I don't know, Mumbai made this app that's making him $2,000 a month. And that's like so interesting because he like really digs into it, like how'd you get started, how did it work, blah, blah. And it's just so inspiring hearing these stories. And you get some people who are like, you know, some dude in America who built an app that makes him $500,000 a month. And he does basically like half an hour of work a week for it. Like, it's absolutely next level. It's so cool. Indie Hackers? Indie Hackers podcast. There's another podcast that's really good called My First Million, which is run by The Hustle Newsletter. And that talks about, you know, how people made their first million, kind of how they got started, how long it took to get there, well, any tips they have along the way, you know, if they had to start again completely from scratch, how would they go about becoming a millionaire, assuming they couldn't use the network and stuff like that? So those two are really good, Indie Hackers and My First Million for aspiring young entrepreneurs. All right, we've got a question from underscore Airman, who says, what's the secret to a good life? Didn't think you were going to take that question. Secret to a good life? Balance.  And the more you can stimulate yourself by doing new experiences or getting involved in different things, the easier it's going to be to stay fulfilled. I like to do as many different things as I can. That keeps me happy. Yeah, I fully agree. I think having a full-time job is never going to be fun, because you're kind of stuck doing one thing for an extended period of time. I think variety is really good. One thing I've started to think about a lot recently is that the secret to a good life is to find the stuff that you like doing and figure out a way of continuing to do that stuff. Certainly for me, for YouTube, I like doing YouTube. There is no end game here. The end game is to continue being able to do YouTube, to keep it sustainable, to keep it fun, to keep it enjoyable. And sometimes people ask me that, oh, what's the next step? Are you going to go on TV? I'm like, no.   And so if you can find something that you like doing and you can just figure out a way to keep on doing it, then I think that's the secret to a good life. All right, question from SMTAR121472 who says, is your life fulfilling? I think yes. Well, I know yes, because I mean, fairly similarly from what I said from the last video, because I try and keep it as varied as possible. And I have these non-negotiables in my life, which are things that make me happy. And I make sure that the things that make me happy are the things that I am doing on a consistent basis.  Like, if you don't feel like hanging out with people, you can just say no. And like, I think that's completely okay. Or if you don't feel like going on a night out or staying out very late, just stay no. Like you can do whatever you want. It's your time. It's your life. Don't feel obliged to make other people happy. But on board with that, I feel fulfilled as well. I think it's sort of a balance between, I think about it in terms of happiness and meaning, like happiness being am I enjoying what I'm currently doing and stuff. And meaning is am I being useful to others? And I think right now I've got a good setup where I've got a large chunk of happiness. And I also have a large chunk of meaning from hopefully being useful to others through these videos and stuff. So yeah, pretty fulfilling life. Alright, final question we've got from Kazianica who says how to get over disappointments. This is a lot easier said than done. But I try to always find some sort of learning point or some sort of learning thing I can take from failure or disappointment. I think as soon as it happens, it's easy to internalize and sort of blame yourself like, why did I do this? This is my fault. I could have done better. I could have done X, Y or Z. And I think it's fine to have those feelings. And in fact, it probably helps in the process of like overcoming the event. For me, time heals everything. I let time pass. And I like think about it. I talk it out with people. And I try and focus on what's one thing I can do that would help avoid this next time or help improve this for me next time. Yeah, I think it's broadly similar for me. Like I think disappointment comes from this mismatch between expectations and reality or hopes and reality. And so one thing that I always try and do is I try and keep my my expectations or my hopes that are outside of my control as low as possible. So for example, I know it's within my control to release two videos week. I know it's completely outside of my control how many views those videos get the initial like I can avoid avoid feelings of disappointment by not having an expectation for how many views something's going to get because it's completely outside of my control. Having said that, when you get a video that tanks on the analytics, you do feel a sense of ah, it does. Yeah. What is my life? Why is it turned out?  Oh, my God. And then I think I and then I have to do all these mental gymnastics to I sort of feel Tim Ferriss and Gary Vee and all the people stoic people sort of screaming in my head being like, no, this is not how you should think, decouple your feeling from reality. It's fine. It's a learning experience. Look what you learned. It's outside of control. All of the all of these kind of mental gymnastics that I eventually have to do and after a while, I'm like, okay, what is it works? These mental gymnastics and changing your perspective or how you think about a situation really helps. It really does work. Emma, it's Hebs law. Axons that fire together wire together. So the more I was like a thing in your in your like, so the more you train for processes, the more they become actually ingrained into the plasticity of your brain and stuff. I find that the more the more I think in this way, the more I'm trained and prone to thinking in that way. And all right, guys, thank you for sending in so many questions. We've definitely had fun reading and answering them. If you guys enjoyed this video, don't forget to leave a like on it and also subscribe to both of our channels. You'll find links to that in the description down below. And yeah, hopefully we'll do this again. Yeah, that's some point in the future. Definitely. You'll come to London next time. I'll come to London next time. And yeah, we'll see you guys in the next one. Peace.