Sorry but I have created a new thread to avoid confusion and I have attached the excel sheet with the desired output.
please help me to get the desired output based on the same data.
Thanks
Hi @suby,
what's the Join rule? I just can't figure it out. Why is it Apple twice and Mango once? and why are all the others ignored?
Why can easily get to a result like this:
But I am not sure what's the rule to get yours:
I'll attach what I did. Take a look and tell us what's the exact Join rule.
Best
Alex
Updated workflow attached.
Try to click on the little icon next to the name. This downloads the yxmd file for me.
If you don't have a more general rule, yes - you would have to include all.
Thanks for sharing but I cant download the workflow. Can you please resend the workflow.
In my case.
Steps I followed.
1) Used the Input Tool to bring the Two tables
2)Used the Join tool to Join by ID on Table A & Table B
Then I want the Desired output as per my excel but when I tried to put the Filter tool with the condition below
contains([FRUITS],"Apple")OR contains([FRUITS],"PINE APPLE")OR contains([FRUITS],"MANGO")
the output is picking up first value from the Table B something like this
1 Vegetable ORANGE
2 Vegetable MANGO
But instead what I wanted is
1 Vegetable APPLE
2 Vegetable APPLE
3 Vegetable MANGO
I have updated me workflow to use your Filter.
Output:
It will also produce Mango for ID-2, not sure what's if you missed that in your example or if the ruling has to be adapted. I also added a Unique-Tool to remove duplicates.
Workflow attached.
