Forum Discussion
How to replace values in a column in power query
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"
Try to clean the data first in those columns as there might be few invisible characters.
Transform menu - Format - Clean
Thanks for the suggestion Vijay. But it didn't work either. Still there's error.
DataFormat.Error: We couldn't convert to Number. Details: 1-H
Can you paste some data in a text file or Excel and share through Onedrive?
https://1drv.ms/u/s!AuTuEhWYL9eEjyWPJ1quqFaxW1at?e=tPiIaz
To make it simple I have just selected first 3 columns from my original data.
There are 2 workbooks.
1- Raw Data (The file where I save all my day to day activity)
2- Power Query file (The file where I want the selected columns to be updated automatically as I keep updating my raw data)
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}})