The request exceeds the memory limit

[Sidkar]

When I try to run some code on Qlik Cloud an error pops up that says:

With the error saying:

"The following error occured:

The memory limit for the request was reached

<Sensitive Code>

The following error occured:

Out of object memory

The request exceeds the memory limit."

What is the best work around this?

[rubenmarin1]

Hi, optimize the code, but it's had to give instructions without knowing what the code is doing.

Maybe a join is creating a cartesian product between the rows of two tables, or there are many complex syntehic keys.

[Sidkar]

Thanks for replying @rubenmarin1. Here is the code below for context where it is happening:

LEFT JOIN(X)

LOAD

    "Version #"

    Upper(W) AS W1,

    //Z as Z1,

    "Start Date",

    if(isNull("End Date"),Date(today()),"End Date") AS "End Date",

    "Version Summary"

FROM "file path"

(ooxml, embedded labels, table is Versions);

[rubenmarin1]

Hi, that's only the second part of the join.

Has the X table at least one of the fields generadted by this code? and there are multiple rows with the same values on that field?

If there are many rows with the same values on both tables it will create duplicated, hundreds of the same values on both tables may be converted to many millions of rows in the joined table, potentially causing the memory limit error.