Hi Users ,
Please help me i need to find same values from different csv columns
if match found then i have to search in website url
from above two different csv columns
thanks in advance
Mohini …
happy automation…
Read both of the datas into two datatables dt1 and dt2
then use a join datatable activity with inner join and columns as PayRefID
then you will get output table containing all matched rows
Which can then be looped and used for verifying on the website
Hope this helps
cheers
@Anil_G ,
I have used but no data has enter in new excel
@Anil_G
In join as inner and column name =column name
How about the following?
read the two CSV files and store each file in 2 differentes datatables, then create a new result datatable with the following code
(From r In dtInput
Join k In dtValues
On CStr(r("Column1")) Equals CStr(k("Column1"))
Select dtToWrite.Rows.Add({r("Column1"),r("Column2")})).CopyToDataTable
Here is an example
Main.xaml (14.3 KB)
Regards
1 Like
Hi @anon87560229 ,
Could you also show us the Configuration done in the Join Datatables Activity ?
@anon87560229
Please share join data table activity screenshot
(Join wizard)
@Jithesh_R
PFA
@anon87560229 ,
Yes the configurations are right.
But please make sure the Column Names
Regards,
@Jithesh_R
@Anil_G
@supermanPunch
@fernando_zuluaga
Thanks for efforts i tried all the ways so at last i create topic
i think its password protected excel i have given password also dont know the issue
Thanks in advance
Are you getting the input data into datatable first?
If password protected there is option to provide password…please check by runnign in debug if you are getting the data or not
cheers
In that case, Could you Check the values of the dt1 and dt2 datatables in the Debug Panel.
Set a Breakpoint and Check the datatable values using the Immediate Panel.
If possible, provide it screenshots, check if there are any differences between the two columns.
Yes i given password in properties panel and also data is coming
Then can you open datatable in locals panel and see if the data is matching or there are any extra spaces or any special characters in one of the tables
cheers
Hi User,
it just Shows adding column values no data is coming correct in both DT
output is like this and matching no are 41521,41525,41528
Please help
Thanks in advance
I have shown everything in this topic
Please refer that I cant share excel file n workflow
Thanks
Hello, im new in forum but i want to help if ican. Sorry for my poor english.
Can you check datatype of both datatable?
It looks like datas are diferent, one is number and other is number save as text.
1 Like