Forum Discussion

Manikanadan-R's avatar
Manikanadan-R
New Member
4 years ago
Solved

How to replace values in a column in power query

I am trying to take only selected columns from my raw data for report which will be automatically updated when I add details in my raw data file.   The raw data file has so many columns including "...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    You had used int64.type for Invoice No which won't work for alphanumeric data type. The same needs to be changed to text.

    Look below the step where I have changed it to text

    Table.TransformColumnTypes(#"Promoted Headers",{{"Branch", type text}, {"FY", type text}, {"Invoice No", type text}})
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    try to delete the step of "Change Type"

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

You had used int64.type for Invoice No which won't work for alphanumeric data type. The same needs to be changed to text.

Look below the step where I have changed it to text

Table.TransformColumnTypes(#"Promoted Headers",{{"Branch", type text}, {"FY", type text}, {"Invoice No", type text}})
Manikanadan-R's avatar
Manikanadan-R
New Member
4 years ago

Thanks for your time and effort suporting me. Appreciate that. Your answer gave me a spark. Eventhough it didn't work in my case, I checked where it went wrong and found that the "Change Type" step was the issue. I removed it and cleaned the column as you suggested. It worked. Later I saw the same solution posted by Mr. Daniel in this post. Thanks!! Have a good day!