![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/4eededfc-b2b7-4c30-bc29-9149aefde10d.png)
Input data:
[
{
"product_id": 1,
"unit_price": 23.2
},
{
"product_id": 4,
"unit_price": 21.64
},
{
"product_id": 2,
"unit_price": 10.87
}
]
Delta lake lookup table. This is same for all operations performed
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/d76b375f-984f-4f99-82b4-baf549cb27d9.png)
Return all matching rows, generating a record for each match:
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/68aa6c64-2456-4de3-9896-5a657ccc5ba9.png)
Return first matching row:
There won’t be change in the output from above since there are no duplicates in input.
Return a count of matching rows:
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/f5fe37dd-6f4a-4848-8149-44c15be9e34a.png)
Return true if matches exist, otherwise false:
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/6c81d36e-7e90-4309-a61e-4cb766265bab.png)
Input data:
[
{
"product_id": 1,
"unit_price": 23.2
},
{
"product_id": 2,
"unit_price": 21.64
},
{
"product_id": 4,
"unit_price": 10.87
},
{
"product_id": 5,
"unit_price": 99.32
},
{
"product_id": 4,
"unit_price": 20.33
}
]
Return all matching rows, generating a record for each match:
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/a24a832e-b014-4c0f-965d-0c33ed01b6bc.png)
Return first matching row:
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/9e94de48-8aa6-48f1-91a2-cca105090c94.png)
Return true if matches exist, otherwise false:
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/4e3b5d5a-f50c-44a6-9af7-425682bf6ec2.png)
Return a count of matching rows:
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/85ba509a-95c6-4cc2-8c7c-0cd69068fd3a.png)