How to get a text from excel

Can you help me how can we do that?


Hi @raju_alakuntla

Read both the tables in 2 DataTables using Read Range.
Use the Join DataTable activity:
Select Inner Join: Give both the column names.
And store the result in new DT.


getting this error

Can you check your DT2 Variable?, doesn’t looks like its a DataTable type

@raju_alakuntla . If DTAP’s are unique then we can get the ticket number’s based on the matched DTAP’s by using LINQ

step1: read the 2 tables in dt1, dt2

step2: use build data table activity and pass one column name (Like " TickeNumber") and store the that table in dt3

step3: take one assign activity add dt3 in left and write below linq in right.

( From d1 In dt1.AsEnumerable Join d2 In dt2.AsEnumerable On d1(0).ToString Equals d2(0).ToString
Let x = New Object(){d1(0)}
Select dt3.Rows.Add(x)).CopyToDataTable

Najeer Shaik.

can we connect once in google meet??

( From d1 In dt3.AsEnumerable Join d2 In dt2.AsEnumerable On d1(“ColumnName”).ToString Equals d2(“ColumnName”).ToString
Let x = New Object(){d1(“ColumnName”)}
Select dt3.Rows.Add(x)).CopyTodataTable

Yes sure, we can

join now

what happened?? can you join now??

@raju_alakuntla Joining now. Please join now

@raju_alakuntla Please join waiting for you.