Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Extract Unique Values from Semi or Unstructured Excel
This bot can be used to extract the value of unique keywords from unstructured Excel files
Top Benefits
- The value of unique keyword can be extracted from unstructured Excel
Tasks
- Identify the keywords whose value needs to be extracted.
- Use Excel advance package.
- Use the Find command to search the Keyword.
- The list variable will be generated and which in turn can be evaluated to read the value of the keyword.
This bot uses the “find” command from the Excel advanced package.
The user must pass a unique keyword that he/she wishes to search for and then extract the value of it.
The find command will search the keyword and gives output in list variables.
The value of a unique keyword can be evaluated by the list index.