How to solve this?

Help Activities
, ,
1

Having a Dynamic excel which is changing every time and another excel is called standard excel.
I try have to compare with contains operator with the Standard excel with Dynamic excel but its getting an error while comparing.

Need to check the data in Dynamic excel with Standard excel if it is contains those values in Standard Excel, then count the values in session column in Dynamic excel and store in one variable.

other values will store in another variable.

Dynamic Excel:Dynamic Excel.xlsx (23.2 KB)

Standard Excel:Strandrad Excel.xlsx (9.6 KB)

Can you please help for this query

Thanks in Advance

2

Hi

We can try with JOIN DATATABLE where it will get the matching records with Join methods and once after getting the output datatable we can add the session column for total value

Cheers @keerthi_arumugam

1 Like
3

do you want to get increased the count by 1 or readout the count?

what is meant in detail?

What about following:

  • filter out all dyanmic excel rows, which are having a match in standard excel?
1 Like
4

yes, Dynamic excel values contains the above standard excel.

I.e :

image
image1435×610 64.1 KB

Take a all the Values which is contain “/campaign/WV-0921/”

5

So it will be interpretated as:
Dynamic
/campaign/WV-0921/?NPCL=CP12
/campaign/WV-0921/?NPCL=HM83
/campaign/WV-0921/?NPCLF=CP12
/campaign/WV-0921/?NPCLF=HM83
/campaign/WV-0921/?NPCLF=PR86
/campaign/WV-0921/?NPCLF=VC65

will rated as match, as we do see
/campaign/WV-0921
on Standard

Feel free to recheck the remaining open questions from above

6

yes Exactly…Dynamic excel contains Standard excel which is take the prefix of the value.

7

read in both excels with read range (dtStandard, dtDynamic

give a try on following:

Create a variable: dtFiltered | datatype = DataTable

Assign activity:
LHS: Result | DataType: List(Of DataRow)
RHS:

(From d in dtDynamic.AsEnumerable
let chk =  dtStandard.AsEnumerable.Any(Function (x) d(0).toString.Trim.StartsWith(x(0).toString.Trim))
Where chk
Select r = d).toList

then check within an if acitvity
Result.Count > 0
Then: dtFiltered = Result.CopyToDataTable
Else: dtFiltered = dtDynamic.Clone

So it will filter out from Dynamics all rows with a match in Standard

8

Thank will try and let you know

9

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