Excel If Read Cell

[ridvanucok]

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

[Che]

@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.

Then process the resulting data in the DataTable.

Kind Regards

[Shikhar_Tandon]

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

[Sadmim_Hossain1 (Sadmim Hossain)]

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.