HI DNA Team,
merge contains.xlsx (171.9 KB)
I will appreciate your help if this is possible,
I would like to merge both tables together in other to achieve the result below
The description column contains invoice number in the text string there that can be found at the beginning of the text, at the end, or in the middle.
The second table contains invoice numbers and the codes that I would like to add to my data.
Is it possible to add the column “Code” to the first table in PQ Model?