# Reverse v lookup is possible to get mismatched data

**URL:** <https://community.automationedge.com/t/reverse-v-lookup-is-possible-to-get-mismatched-data/3447>\
**Category:** Process Studio\
**Created:** [May 21, 2021, 2:31pm UTC](https://community.automationedge.com/t/reverse-v-lookup-is-possible-to-get-mismatched-data/3447 "2021-05-21T14:31:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rahul](https://avatars.discourse-cdn.com/v4/letter/r/f14d63/32.png) [@Rahul](https://community.automationedge.com/u/Rahul)\
**Post date:** [May 21, 2021, 2:31pm UTC](https://community.automationedge.com/t/reverse-v-lookup-is-possible-to-get-mismatched-data/3447/1 "2021-05-21T14:31:24Z")

</div>

Dear team,

Please provide the availability of plugins which can provide unmatched data from stream lookup plugin I.e. reverse v-lookup.

Regards,  
Rahul hande  
9870206074

---

<div class="post-metadata">

**Author:** ![Aakash\_oswal](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@Aakash\_oswal](https://community.automationedge.com/u/Aakash_oswal)\
**Post date:** [May 24, 2021, 10:54am UTC](https://community.automationedge.com/t/reverse-v-lookup-is-possible-to-get-mismatched-data/3447/2 "2021-05-24T10:54:41Z")

</div>

There is no specific plugin step.

You can achieve it by combination of below plugin steps  
Stream lookup , Multiway Merge Join and filter row it can be achieved

---

<div class="post-metadata">

**Author:** ![Rahul](https://avatars.discourse-cdn.com/v4/letter/r/f14d63/32.png) [@Rahul](https://community.automationedge.com/u/Rahul)\
**Post date:** [May 29, 2021, 10:17am UTC](https://community.automationedge.com/t/reverse-v-lookup-is-possible-to-get-mismatched-data/3447/3 "2021-05-29T10:17:16Z")

</div>

Dear team,

To multiway join has no true and false output hopes.

To filter we can’t join two input hopes.

Please provide any suitable solution .

Regards,  
Rahul hande

---

<div class="post-metadata">

**Author:** ![Aakash\_oswal](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@Aakash\_oswal](https://community.automationedge.com/u/Aakash_oswal)\
**Post date:** [May 31, 2021, 4:53am UTC](https://community.automationedge.com/t/reverse-v-lookup-is-possible-to-get-mismatched-data/3447/4 "2021-05-31T04:53:55Z")

</div>

Hello

First use Multiway Merge Join for full outer Join then pass the output data to filter and filter the Selected field is Null . You will Get the Required Output.

Thanks & Regards  
Aakash Oswal