Hi , I need to compare two columns in excel and if the value matches, i should skip the matching value and write the un-matching values to new column. [forumques] please find the image and requesting your help on this here i’m comparing the column P and column S , so if the values matches. i sho…

maybe the simple string approach will work For the Check row("ESQ-AC Codes").toString.Contains(row("Gasper Action Code").toString.Trim) Replace: row("ESQ-AC Codes").toString.Replace(row("Gasper Action Code").toString.Trim,"")

Hey @ppr , Thanks for the immediate response and i’m trying with the inputs you have given. will update once it is successful. Regards, Naveen Kumar

Hello @naveenkumarr Kindly refer this xaml file, Used activities For each data table Write cell Split For Each loop Collection List Forum_ExcelRemoveData.zip (83.7 KB)

Hey @ppr , It works, thanks <3 And thanks gokul for the information :slight_smile: Regards, NaveenKumar

Comparing Excel columns

Help Studio

ppr (Peter Preuss) September 8, 2022, 8:00am 3

A multi code handling could look like this

grafik

Forum Engagement Daily Reports

Topic		Replies	Views
Please need help to Get the different between 2 columns in Excel sheet Academy Feedback activities , studio	20	3334	January 9, 2019
How to compare row value with column value? Activities excel , excel-tables , excel-compare , row-and-column , compare-row-with-column	2	1187	September 13, 2022
Comparing two columns in Excel not rowwise Help datatable , excel , activities , studio	17	2812	September 22, 2019
Compare 2 columns in a single excel sheet Activities excel , activities , studio	2	612	September 19, 2022
I want to compare two columns from two different excel sheet Help	17	6720	October 7, 2021

Comparing Excel columns

Related topics