topic Applymap - Clear from memory in App Development

Applymap - Clear from memory

juleshartley — Sat, 16 Nov 2024 02:57:42 GMT

Hi,

I just wondered if anyone knew of a way to clear out any mapping loads from memory mid way through a load script?

Perhaps load again with same table name but no rows?

We have a very memory-intensive load and it might help to streamline it.

Thanks

rwunderlich — Tue, 17 Mar 2020 20:24:57 GMT

I don't think it's possible. My experience is that once you create a Mapping table, you cannot modify it. For example, concatenate will not add rows.

-Rob

dwforest — Tue, 17 Mar 2020 20:35:00 GMT

You could load it as a normal table and JOIN the results instead and drop when done