Avoid Synthetic Tables

[suzel404]

Hi,

I want to avoid sync tables in my case.

Regards,

[rubenmarin1 · Accepted solution]

Hi, you can create a composite key using both fields:

LOAD %OPERATION &'_'& %DESPENSE as KeyField,...

One of the tables can have the fields separated, or you can create a new one thas relates each KeyField with his correspondent %OPERATION and %DESPENSE