Comparing Excel columns

Help Studio
, ,
#1

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 should skip the matching number i.e 26 and write 34 and 7 in the column Q

#2

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,"")

1 Like
#3

A multi code handling could look like this

grafik

1 Like
Forum Engagement Daily Reports
#4

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

#5

Hello @naveenkumarr
Kindly refer this xaml file,
Used activities

  1. For each data table
  2. Write cell
  3. Split For Each loop
  4. Collection List
    Forum_ExcelRemoveData.zip (83.7 KB)
1 Like
#6

Hey @ppr ,
It works, thanks <3

And thanks gokul for the information :slight_smile:

Regards,
NaveenKumar

#7

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