Forum Discussion
Solved
Return matched values
Dear altruists, I have a column with many values which can be increased, such as; Column 1 Apple Pear Kaki Avocado etc... These values I want to find in another column, for multiple val...
I have taken your sample set and produced the below output
I created TBL1 which has Columns 1 and TBL2 which has the Column 2 containing text within which Column 1 is to searched.
The Custom column was created using the below Transformation step
If the solution matches your requirement, please let me know I will upload the PBIX file
Hi Manjo, it worked , thanks a lot. Have a good day.