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...
As variant that could be done by Power Query - split Manufacturer SKU texts to lists, expand to rows, merge with mapping table, combine back to texts
Query is in attached.
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=List
