Excel comparison with 100k line items each

[Ranganathan_M]

Hi
Iam comparing two excels using for each by having if condition in it.
Comparison is taking too much time…
Since each sheet contains around 88k and 45 k respectively.

Kindly provide me your suggestions to do comparison in short time. @Palaniyappan

[Anil_G (Anil Gorthi)]

@Ranganathan_M

Did you try the solution provided already?Is the time not reduced?

I want to compare two excels and update the data in third sheet in excel where each sheet contains 100k line items

@Ranganathan_M Yes even then we can still use it… Once downloaded use copy sheet and copy both sheets to same excel where 3rd sheet is there and then use write cell to write the required formula…and then auto fill range to fill it till end Cheers

Cheers

[Ranganathan_M]

My need is not related to that.
Kindly provide any alternates solution for this…Like query or something @Anil_G

[Anil_G (Anil Gorthi)]

@Ranganathan_M

Can you please provide a sample file of what input looks like and what output is needed…

Cheers

[supermanPunch (Arpan)]

@Ranganathan_M

Comparison is taking too much time…
Since each sheet contains around 88k and 45 k respectively.

Hi @Ranganathan_M ,

Could you let us know in some more details as to what comparison are you trying to perform ? What is the Output from the Comparison?

If you have got the Solution already, Do post the methods/Steps and mark it as the solution as it would help others who are facing the same issue.

[ppr (Peter)]

LINQ query running for long hours

Let us introduce the next changes [grafik] we are creating lists with the concatenated strings from dtold, dtnew and creating a dictionary of only the items common in both lists dtNewSet.asEnumerable.Select(Function (x) String.Join(“#”, arrColSet.Select(Function (k) x(k).toString.ToLower.Trim))).Distinct().toList dtOldSet.asEnumerable.Select(Function (x) String.Join(“#”, arrColSet.Select(Function (k) x(k).toString.ToLower.Trim))).Distinct().toList ListDT1.Intersect(ListDT2).ToDictionary(Fun…