Like Filter in between two data tables

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.

1 Like

Hey,

Try with join datatable activity and this will solve your issue.
https://activities.uipath.com/docs/join-data-tables

Regards,
Pavan H

3 Likes

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

1 Like

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

2 Likes

image

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

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

2 Likes

Thanks Pavan!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.