This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I'm comparing two files with 400+ fields using multiple fields formula.
Trying to the get result like below:
As lots fields involved, I'm editing XML directly.
The source file is only with 300 records for testing, but I notice the PC become slow ,(from task manager , AlteryxGUI.exe using 9G memory on the 16 Core, 32G work station.) and later start getting below exceptions.
AlteryxGui.exe - Exception
Breakpoint A breakpoint has bean reached.
Alteryx Desinger X64
An out of memory exception happened, the application may not be able e to recover.
Do you wan to exit?
I'm using Alteryx Desinger X64 version 2018.4.4.54346. How can i trouble shoot such issue or any diagnose log etc?
Also i notice the Multiple-Field Formula's message/input/output is showing nothing though there are data flowing.
While Alteryx can work with large numbers of columns it does start to slow down when you reach ~1000 fields. A lot of this has to do with the amount of metadata that Alteryx maintains about the datasets. You might want to consider transposing your data to bring it all into a single column and using a single formula tool.
This has the added benefits of 1. providing the output in field order and 2. Reducing the complexity of the overall workflow by having a formula tool that acts on a single column as opposed to a very large multi field formula.
I would still open a ticket with Alteryx support, since you shouldn't be getting the error message in the first place