🔥 3-day streak
Microsoft Power BI Data Analyst192 / 205
Question 192 of 205

You import a customer table from a CSV export. When you merge it with an Orders table on the CustomerCode column, many rows that should match return null. On inspection, some CustomerCode values in the CSV contain trailing spaces and non-printable characters carried over from the source system. In Power Query, which combination of transforms should you apply to CustomerCode before performing the merge?

Reviewed for accuracy · Report an issueNext question