Forum Discussion
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 "...
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}})try to delete the step of "Change Type"
wdx223_Daniel
Community Champion
Community Championtry to delete the step of "Change Type"
Thank you so much for your help Daniel. It worked.
