Comparing complex information with specific list

Help Studio
1

Comparing complex information with specific list

Use Case Description

Hello, I have a 2 columns related to car models. The input is export from the core system defining specific format we need. E.G. for Brand AUDI, I need Models like Q8, A8, etc.
However, I receive from the client an excel where Brand AUDI, has in column Model Quaddro 8 Diesel 2.0 100 Kw or Diesel Q8 220 KW, etc. And I need to match this with Q8 in my specific list.
Is there a way how to do this?

AS-IS WORKFLOW, TO-BE WORKFLOW

-

Other information about the use case

Industry categories for this use case: Insurance

Skill level required: Advanced

UiPath Products that were used: UiPath Studio

Other applications that were used: -

Other resources: -

What is the top ROI driver for this use case?: Accelerate growth and operational efficiency

2

Hi! You can store your comparing values in a file and check with “.Contains”.
For example, in your case with “Model Quaddro 8 Diesel 2.0 100Kw” or “Diesel Q8 220KW” you can check whether it contains Q8 or Quaddro 8 and if any of these are true then it should be fine.

You can have more than 1 comparing criteria, here we have 2 (Quaddro 8 and Q8) so you can add them to an excel file, lets suppose that the first column is the brand (in this case Audi) and in the second column you have the criteria separated by comma (Quaddro8,Q8). When you want to check if these keywords are there, you can use String.Split(“,”).ToList to convert it to a list and for each item of the list you compare. For every successful comparison you increment a counter (let’s call it ContainsCounter). If the ContainsCounter >= 1 it means it managed to find at least one value that is contained in the specific item that you searched.