Forum Discussion
Change letter and numbers
Hello, I have about 22000 lines with SKU product numbers from the manufacturer. I want to sell their products with my own SKU numbers, but I want my SKU numbers to be based on their SKU number. Ho...
SergeiBaklan I believe something goes wrong in the "Expanded CharMap1" step and subsequent grouping (Text.Combine). I seems to throw the order of characters around. For example, "TQC603" should be "TC6Q03".
You are right, thank you. Forgot to fix table in memory before expanding. Here is by adding the index, Table.Buffer() will work as well.
SergeiBaklan Expression.Error: 5 arguments were passed to function which expects between 2 and 4.
Details:
Pattern=
Arguments=ListFifth explicit argument defining the data type was added to Table.AddIndexColumn() recently, somewhere mid summer. On older versions of Power Query you shall delete it, but I'd recommend to update Power Query instead, otherwise you'll have compatibility issues in future.
