topic Re: What Type of Error is this? in Alteryx Designer Desktop Discussions

What Type of Error is this?

Uthpala_Koralegedara — Wed, 26 Jun 2019 04:33:09 GMT

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!

Re: What Type of Error is this?

andyuttley — Wed, 26 Jun 2019 06:48:35 GMT

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?

Re: What Type of Error is this?

afv2688 — Wed, 26 Jun 2019 08:52:00 GMT

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

Re: What Type of Error is this?

Uthpala_Koralegedara — Wed, 26 Jun 2019 22:30:54 GMT

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

Re: What Type of Error is this?

Uthpala_Koralegedara — Wed, 26 Jun 2019 22:35:37 GMT

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.