What Type of Error is this?

[Uthpala_Koralegedara]

Hi,

I am receiving the below error while trying to combine large sets of data.

Can you please advise what I am doing wrong.

Thank you!

[andyuttley · Accepted solution]

Hi

It looks like the Find Replace is struggling to handle that volume of data.

Are you able to use a join tool instead? Are you just using it to join the two datasets?

[afv2688]

Hello @Uthpala_Koralegedara ,

What the error "out of memory" is telling you is that your machine is not able to work with those amounts of data, needing higher specs.

Also, find replace is not suited for working with large datasets. Try either to use the join tool as @andyuttley  suggests or to use in DB tools (if you are downloading the data from an SQL for example).

If you need to work with those datasets anyways would recommend you to split the data if possible.

Cheers

[Uthpala_Koralegedara]

Thank you @andyuttley, I think I was too ambitious. Will run the dataset with the join tool and split the analytics into different steps.

[Uthpala_Koralegedara]

Thank you @afv2688, I will split the data and do the analysis rather than trying to do everything at once on the entire data set.