script

[Carlaf_93]

Good morning,

i have three table and a autocalendar.

table1:

load

data,

cod,

value1;

table2:

load

cod,

detail_code,

area1;

table3:

load code,

data, 

value3;

autocalendar using data;

i would like to change the area1 when  code is '010' and data is < 2017. 

[Taoufiq_Zarra]

@Carlaf_93  can you share a sample data and the expected output ?

[Carlaf_93]

Here are the tables. 

I would like to get: if data>2018 and code=10 area1 like management if not finance