Dear all. new to UiPath, i have this big project, where i need to match the values from columns. The files are CSV and XLSX. the CSV file column has more values and i only wan’t to fetch one specific word from it. as you can see i use for each row to loop trough all my DT to match and a match t…

Hello Christina Please take a look at this previous post, perhaps it will help you: [image] Comparing data between two Excel file Studio Hello Please take a look at the attached example below. [image] Compare data.xaml (16.6 KB) Best regards, Soren Regards Sore…

@Christina_Ilkjaer_Peterse Welcome to the forums there are few other options (maybe with a more compact modelling result) but as you have mentioned: [image] Christina_Ilkjaer_Peterse: new to UiPath we will stick to your started modelling We assume that you want to compare/check column val…

i can’t share my xaml file, because is a work thing. But let us say that i have to compare column C, in the column there is a lot of tekst, but i only need a specific word from it, to compare with the other column that only has the specific word in it. to see if it is there or not. Skærmbillede 2…

@Christina_Ilkjaer_Peterse unfortunately we cannot derive the needed details have a look at such flow <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/8/f/a/8fafc6133d648eeaebb916a915651dc10fe6509a.png" data-download-href="/uploads/short-url/kv6S31UK4f7wAXIYgP6nbl8Enuq.png?dl=1" title="The image shows a table listing variables with their names, types, scope, and default values in a sequence, specifically for two DataTables, a Match, and a String variable. (Captioned by AI)">[The image shows a table listing variables with their names, types, scope, and default values in a sequence, specifically for two DataTables, a Match, and a String variable. (Captioned by AI)] …

How to compare to excel files, with uniqe and more values reference tekst

Help Community

SorenB (Søren Schytz Birk) August 21, 2024, 1:57pm 5

Hello Christina

Please take a look at this previous post, perhaps it will help you:

Regards
Soren

Topic		Replies	Views
Compare two excell sheet Activities	16	156	October 7, 2024
Comapre two columns from two excel sheets Help	26	6234	August 21, 2019
Compare two excel files Help	8	1721	November 27, 2019
Compare 1 row with multiple columns to another Excel File Studio studio , question , activities_panel	14	983	September 21, 2022
Compare each line of row of 2 excel file Studio datatable , studio , question	15	1129	October 4, 2022

How to compare to excel files, with uniqe and more values reference tekst

Related topics