Clean function in power query is found in ------tab?Options :HomeTransformAdd columnView

Breakdown the Problem

1. Identify what the "Clean" function does in Power Query.
2. Determine which tab among the given options contains this function.

Relevant Concepts

1. Power Query is divided into various tabs, each serving different purposes:
   • Home: Basic file operations and queries.
   • Transform: Data transformation operations.
   • Add Column: Creating new columns based on existing data.
   • View: Adjusting the view of data and query settings.

Analysis and Detail

1. The "Clean" function in Power Query is used to remove non-printable characters from a text value.
2. Typically, text transformations, including the Clean function, are found under the Transform tab.

Verify and Summarize

Based on the functionalities associated with each tab, it is confirmed that the "Clean" function is associated with data transformation.

Final Answer

The "Clean" function in Power Query is found in the Transform tab.