Forum Discussion
Complicated Merge in Power Query
Create a custom column in the query editor that checks the first character to see if it's a digit and then take 2 or 4 characters depending on the result.
if Text.Contains("0123456789", Text.Start([SPECIFIED CODE],1)) then Text.Start([SPECIFIED CODE],2) else Text.Start([SPECIFIED CODE],4)Then you can do a normal merge using this new column.
The desired output is already in the post. Where I mention my report table I inserted a column called (what I want) PRODUCT
I saw that but I was confused by the "first 2 letters of the numeric serials" some of examples of what you expected the results to look like in the Product column would help ensure you are helped correctly the first time around. AlexisOlson may have understood your request better then I and provided a solution
Yes, the first 2 letters for the index serials with numbers in them will always be the same. The numbers afterwards are unique to each specific product purchased. Where the first 2 numbers are the identifiers. Thank you for putting out that confusing bit! Thank you for reaching out and trying to help. I'll definitely see what Alex Olson recommended.