How to store data in memory or pass data around?

CloverDX Platform
1

Hi,

I want to achieve the following:
Phase 1: Execute SQL query and store result in some sort of variable A (e.g. number of rows before processing)
Phase 2: Execute SQL transformation query (data processing)
Phase 3: Execute SQL query and store result in some sort of variable B (e.g. number of rows after processing)
Phase 4: Compare variable A with B. If A not equal B → fail

I can’t figure out how I can store the query result in a variable for later comparision.
How can I achieve this?

2

Hi cternes,

you can use Dictionary - http://doc.cloveretl.com/documentation/ … onary.html for this purpose.