topic For Loop for table in Product Forum

For Loop for table

MichalisGemisto — Fri, 06 Aug 2021 13:47:00 GMT

Hello everyone,
is there any way to loop the items/certain field of a table (not array)? Also, is there additional info about formula language apart from the user-guide?

Thanks a lot,

------------------------------
Michalis Gemistos
------------------------------

RE: For Loop for table

ewilson — Fri, 06 Aug 2021 14:00:00 GMT

Hi @MichalisGemisto,

I assume when you refer to looping a table you're actually talking about looping over a Collection data item? As for the Calculation stage and the possibilities, there are some training labs available on the Digital Exchange that go in to some detail. There's additional training available on Blue Prism Learning Lounge. Do you have any specific questions?

Cheers,
Eric

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: For Loop for table

MichalisGemisto — Fri, 06 Aug 2021 14:08:00 GMT

Hi Eric, thanks for your quick reply.

I have created a table in the DFD for all the products in the product list of an invoice. That table has a number of parametric variables ( using :# you can get their value). So now I want to calculate the overall amount of the products for that invoice by looping on all the products on the product list/table. Thanks for the additional info about the training I will definitely have a look at them.

------------------------------
Michalis Gemistos
------------------------------

RE: For Loop for table

Ben.Lyons1 — Fri, 06 Aug 2021 15:11:00 GMT

Hi Michalis,

Sounds like you're looking to sum a column of values. E.g. SUM(item_value).

For this you'll need to add a field to the header section of the DFD, then you can use the SUM formula and the column name.

The online help is all there is right now in terms of formula detail, are there any in particular you'd like to know about?

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------

RE: For Loop for table

MichalisGemisto — Mon, 09 Aug 2021 13:43:00 GMT

Hi @Ben.Lyons1,

thanks for the answer, everything seems to be working fine with your suggestions. I would like to know if there can be two expressions inside a formula. I know that you can have nested functions ex. IF( IF( statement, if_true, if_false), yes, no) but in my case having two independent IFs ex.

if(something, do this, do that)

if(something_else, do this 1, do that1)

is more useful. (I have tested that above example and I know it is not valid, however I am wondering if there is something else that can be done.)

------------------------------
Michalis Gemistos
------------------------------

RE: For Loop for table

Ben.Lyons1 — Tue, 10 Aug 2021 08:10:00 GMT

Hi Michalis,

Absolutely, nested formulas are a great way to get the most out of Decipher. Check on the formula help page for everything that's available for use http://bpdocs.blueprism.com/decipher/user-guide/formula-language.htm

And if you need any advice on how to combine them, let me know.

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------

RE: For Loop for table

MichalisGemisto — Tue, 10 Aug 2021 10:56:00 GMT

Thanks

------------------------------
Michalis Gemistos
------------------------------