Power QueryExercises

Duplicate a column before changing it (logistics)

IT wants a lower-case Login built from Email, while HR needs the Email column left exactly as typed.

Level
beginner
Time
~5 min
Task
Build the query
Access
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

Duplicate a column so you can transform the copy and keep the original.

Harbour Freight is a fictional logistics firm. HR exports its roster from the payroll system before each review cycle.

Steps

  1. Add Login as a copy of Email, then make Login lower case.
  2. Leave Email exactly as it is (some addresses have capital letters).
  3. Output EmpID, Email, Login.

Your result must

  • Email unchanged
  • Login is Email in lower case
  • Three columns

Input

  • Roster (table)
    • EmpID: text
    • FirstName: text
    • LastName: text
    • Department: text
    • City: text
    • Salary: number
    • StartDate: text
    • Manager: text (nullable)
    • Email: text

Expected output columns

EmpID (text), Email (text), Login (text)

First 3 of 9 expected rows
EmpIDEmailLogin
E100Esi.duarte@HARBOURFREIGHT.EXAMPLEesi.duarte@harbourfreight.example
E101priya.duarte@harbourfreight.examplepriya.duarte@harbourfreight.example
E102Yara.lindqvist@HARBOURFREIGHT.EXAMPLEyara.lindqvist@harbourfreight.example