Merge & extract length

Your manager has decided to implement a naming convention for reseller sales rep names so they are easily distinguishable from Adventure Works own sales reps.

Your manager has also informed you that there is a limitation in the CRM software we are using that truncates any names with more than 24 characters, so he has asked you to verify the length of the longest name in the reseller dataset.

If you lost any progress, load the workbook 3_2_merge_extract.pbix from the Exercises folder on the Desktop and open the Power Query editor.