How to get a text from excel

Help Studio
21

Can you help me how can we do that?

Regards,

22

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.

Thanks

23

image
image1276×448 24.6 KB

getting this error

24

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

25

@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

Thanks,
Najeer Shaik.

27

can we connect once in google meet??

28

( 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

29

Yes sure, we can

30

join now

31

what happened?? can you join now??

32

@raju_alakuntla Joining now. Please join now

33

@raju_alakuntla Please join waiting for you.