From the course: Excel: Power Query (Get & Transform)
Join today to access over 23,100 courses taught by industry experts.
Add conditional and custom columns - Microsoft Excel Tutorial
From the course: Excel: Power Query (Get & Transform)
Add conditional and custom columns
Let me introduce you to conditional and custom columns in Power Query. You'll see more of these as the course goes on. Hence, I want to stress that this is an introduction. Here we've got data about an event that's coming up. We've got names and preferred names. We see that Isaac prefers to be called Skip. He's a member. He's assigned to Table 2, and his confirmation is TKQ196. Scroll down. We have a few more. We go down to Wyatt. Let's bring the data into Power Query and meet conditional and conditional columns. Cursor is in the dataset. Right-click, Get Data from Table/Range, table has headers. Scroll down. Yep. It is encompassing our whole dataset. Scroll back down and okay. Let's do the name badges. Basil wants to be called Basil, but Arnold wants to be called A.J. Let's do that with a conditional column. Add Column, Conditional Column, put Badge. If the preferred equals null, then choose a column, grab the name. Otherwise, select a column, preferred. Okay. I can grab this column…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.