cross tables with conditional.

[Richard3]

I have my tables A and B, my main table must be B, but when B does not contain a value, which in this case is the amount produced for a month, it brings me the value of that month in table A and It generates my table AB.

Example

[AgatheClero]

Hi @Richard3,

You can use Exists function to solve your case.

Firstly, load your file TableB. Then, load your file TableA and filter to load only row where the month is not in TableB (Where not Exists(Month)).

TableB:
Load
    Month,
    [Amount produce]
From <YourFileB>
;

Concatenate(TableB)
Load
    Month,
    [Amount produce]
From <YourFileA>
Where not Exists(Month)
;

Hope this helps.

Regards,

Agathe.