Filter Collection with SAP Data

AsitabhaDeb — Tue, 15 Dec 2020 14:11:46 GMT

Hi Experts,

I have two collection. One is excel collection and another from SAP (Convert SAP data into collection by read stage) There are only one data( One Component# out of multiples) which is present both the collection.

Now my requirement is BOT will pickup that data ( Component#) from excel collection and search in SAP collection if found then move to next stage if not then stop the process.

Please help me on urgent basis.

BR/Deb

Re: Filter Collection with SAP Data

zdenek.kabatek — Wed, 16 Dec 2020 13:53:36 GMT

Hi, Asitabha,

you have at least two options:
1. you create two loops and first one will be the excel one and you will search in the second loop (SAP one) for the component#. In case you find it you jump out of the loop and continue with whatever steps you need.
2. you create one loop - the excel one - and you will use filter collection action (Utility Collection Manipulation) which will return an empty collection (no match found) or non empty collection (match found) and you continue based on that.

Regards,

topic Filter Collection with SAP Data in Product Forum

Filter Collection with SAP Data

Re: Filter Collection with SAP Data