187a2b28-b899-4585-a5b4-488c02a0ffaf.jpg

Automation Developer

The only input you need to provide is the exe name e.g if you want to launch chrome.exe then type chrome as a string. 

With the help of this activity, your program launch path will be dynamic.

  

How to use:

*   If you want to get path of exe for Chrome: ExeName: "Chrome" 
*   LaunchPath: output as string
*   It will return the exe path; if you want to open start program set StartProgram as True if not then False

This activity retrieves the location of the exe file from the Windows registry and allows you to launch the target program

**How does it work?**

  

You have to provide two objects:

a) a DataTable in which you have to find values

b) Dictionary with key as String (column name) and value as an array of strings (values which you are looking for)

  

As a result you can obtain the following output dictionaries:

a) **Present dictionary** – contains columns with the names and values you were looking for – the matched values.

b) **Missing dictionary** – contains the names of the columns and values which are missing.

c) **Leftovers dictionary** – contains the names of the columns and rest values except those which were missing or you were looking for.

d) **Find confirmation dictionary** – contains the names of columns and True or False values – True when all values from the array were found and False if any of it were missing.

  

Example:

DT:

Numbers, Cities, Countries, Elements

23, Szczecin, Poland, Iron

8987, Berlin, Germany, Polon

34, Prague, Czech, Hydrogen

231, New York, USA, Oxygen

11, Moscow, Russia, Mercury

1515, Shanghai, China, Chlorine

125, Tokyo, Japan, Iridium

  

Here are the data which we are looking for:

Numbers:  23, 34, 11

Cities: Berlin, Tokyo

Elements: Mercury, Iron, Oxygen

  

  

Here is how our query dictionary is looking like:

_Dictionary(3) { { "Numbers", string\[3\] { "23", "34", "11" } }, { "Cities", string\[2\] { "Berlin", "Tokyo" } }, { "Elements", string\[3\] { "Mercury", "Iron", "oxygen" } } }_

  

And here are our results:

  

a) Present dictionary (Present\_dictionary)

_Dictionary(3) { { "Numbers", string\[3\] { "23", "34", "11" } }, { "Cities", string\[2\] { "Berlin", "Tokyo" } }, { "Elements", string\[3\] { "Mercury", "Iron", "Oxygen" } } }_

  

b) Missing dictionary (Missing\_dictionary)

_Dictionary(3) { { "Numbers", string\[0\] { } }, { "Cities", string\[0\] { } }, { "Elements", string\[0\] { } } }_

  

c) Leftovers dictionary (Leftover\_dictionary)

_Dictionary(3) { { "Numbers", string\[4\] { "8987", "231", "1515", "125" } }, { "Cities", string\[5\] { "Szczecin", "Prague", "New York", "Moscow", "Shanghai" } }, { "Elements", string\[4\] { "Polon", "Hydrogen", "Chlorine", "iridium" } } }_

  

d) Find confirmation dictionary (Found\_dictionary)

_Dictionary(3) { { "Numbers", true }, { "Cities", true }, { "Elements", true } }_

If we would modify our query with some values which are not in table:

_Dictionary(3) { { "Numbers", string\[3\] { "23", "34",_ _"16"_ _} }, { "Cities", string\[2\] {_ _"Warsaw"__, "Tokyo" } }, { "Elements", string\[3\] { "Mercury", "Iron", "Oxygen" } } }_

  

Then in b and c, we will get:

B’) _Dictionary(3) { { "Numbers", string\[1\] { "16" } }, { "Cities", string\[1\] { "Warsaw" } }, { "Elements", string\[0\] { } } }_

C’)  _Dictionary(3) { { "Numbers", false }, { "Cities", false }, { "Elements", true } }_

  

  

_The step by step manual is available in the documentation in "Powersearch - one-page manual how to use"_

This activity checks if values are present in a DataTable. It returns a Boolean and multiple dictionaries. A boolean variable is True when all values are present and if not, the following dictionaries are created: Present Values, Missing Values, Rest Values.

About me