I have one excel contains 3 columns, am using filter data table to filter the data, the 2nd and 3rd column should match and output as the 1st column data. but value is matching in the 2nd and 3rd column (manually i have checked) but the data is not coming by using filter data table. Can any one ple…

Hi @vanithavs Can you share the sample input and Output Regards Gpokul

Can you please check the column header contains space?

Hello @vanithavs Your actual requirement is not very clear. It would be better if you can share some screenshots or the excel file for better understanding. Also the output required as well. Thanks

Please verify the Check condition and use Trim at the start and end.

I have used trim start and trim end, for some scenario the value is coming and for some scenario the value is not coming (it means empty value is coming).

Check the that condition also in the same datatable “That Column Doesn’t be Empty or null” Check this condition also in the same datatable

Hello @vanithavs , Have a look on the below threads. [image] DataTable filtering with expressions Tutorials Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)()…

[image] vanithavs: I have one excel contains 3 columns, am using filter data table to filter the data, the 2nd and 3rd column should match and output as the 1st column data. but value is matching in the 2nd and 3rd column (manually i have checked) but the data is not coming by using filter data …

Thanks for your reply, There is no space after the header. Am not comparing any date. From the input excel and conversion excel the values are in upper case. Some value is in integer (Ex: 1st column contains BX132, 2nd column contains “365” or “764DB” And 3rd column contains “DTHRSAULT FYRCON 2000…

[image] vanithavs: If the conversion excel cell data contains space starting and ending, how to remove that one. I have tried a lot but i didn’t find any solutions. Use CurrentRow(Column1).ToString.trim

How to filter data from excel?

Help Studio

Sanjit_Pal (Sanjit Pal) September 26, 2022, 5:13am 8

Hello @vanithavs ,

Have a look on the below threads.

Thanks,
Sanjit

Topic		Replies	Views
Filter table by 2 Columns Studio	9	1830	May 7, 2021
Unable to filter the data from the excel Help	49	2692	August 21, 2019
Filter data table activity to remove empty rows Studio excel , studio , question , workflow_diff	7	607	January 26, 2024
Unable to filter data Studio datatable , excel , uiautomation , orchestrator , activities , studio , data_scraping , datatable-filter , excel-automation	2	658	December 1, 2023
[QUERY] FilterDataTable Activity Help	3	2147	December 21, 2023

How to filter data from excel?

Related topics