Excel If Read Cell

I have an excel data like in the table. If column “Kurum Kodu” is TC00, I need to continue activities by reading the data in column “Hostel Servis Adı”. I request your help in this matter.

İşlem Türü Tahsilat Türü Tahsilat Tür Kodu Hostel Servis Adı Kurum Kodu Unvan Abone No Rule Güncellenecek Değer Dönen Borç Adet Açıklama
AA AA AA NYT_TC00_BORC_SORGU TC00 AA 9999999999 AA AA AA
BB BB BB NYT_TC00_BORC_SORGU TC00 BB 8888888888 BB BB BB
CC CC CC NYT_TC00_BORC_SORGU TC00 CC 7777777777 CC CC CC
DD DD DD NYT_TC00_BORC_SORGU TC00 DD 6666666666 DD DD DD

@ridvanucok

Read the entire sheet into UiPath with a Read Range.

Filter out the rows you need with a Filter DataTable activity. You can add a condition for the column value.

image

Then process the resulting data in the DataTable.

Kind Regards

2 Likes

Hi @ridvanucok,

Read your file in a DT say DTBook then you can either use filterdatatable activity or select query like -

Dtnew = DTBook.Select("[Kurum Kodu] = ‘TC00’").CopyToDataTable

This will give you the data with only TC00 values over which you can work.

Thanks

1 Like

Hello,
This can be done using multiple ways depending on the task the process. If you just want to use the DataTable then a filter data table activity will work. But if the process requires per row transaction then you could use for each row in data table activity.

1 Like

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