Like Filter in between two data tables

[Marcusvg]

Hi,

I’m a total rooky and making my first steps in UiPath.
I have two different data tables and i need a “select like” expression.

first DT (columns)
“Data_type” “Date” “Filename”
second DT (columns)
“SSD/NP”

The “SSD/NP” should be found with a like expression in the “Data_type”. The DT should return all three columns of the first DT.

I tried alot with for each row and the filter Datatables actions, but nothing worked for me.

[pavanh003 (Pavan Harisha)]

Hey,

Try with join datatable activity and this will solve your issue.

Join Data Tables

Regards,
Pavan H

[Marcusvg]

Hey Pavan,

thanks for your quick response. I tried that too, but i did not find a “contains” operator.
Is there another way?

Regards,
Marcus

[pavanh003 (Pavan Harisha)]

Hey,
You want first table and matching values from second table or only the matching values.
There is no option of contains in join data table activity.

what exactly is the output you need, can you please give a sample.

Regards,
Pavan H

[Marcusvg]

Hey,

the SSD/NP column from Data Table 2 should be found in Data_type. In this case: row 3 of Data Table 2 is similar to row 3 of Data Table 1. The expected result should be:

Data_type	Date	Filename
No-co NP0392840 TTO	01.01.2019	TCC_01

Thanks for your help so far.

Regards,
Marcus

[pavanh003 (Pavan Harisha)]

Hi,
I would suggest use 2 for loops.
one inside the other.
use if condition to check if row.item(first).tostring.contains(row.item(second).tostring)

This is just logic you can build a workflow based on this if facing issue let me know.

Regards,
Pavan H

[Marcusvg]

Thanks Pavan!