In BW, i have 2 tables:
The aim is to feed field Forced value of Table 2 by reading the table 1 by comparing the accounts (field Account).
The conditions are as following:
If field YesNo = No à Then let field Forced value empty
f field YesNo= Yes à then I have 2 cases to manage:
If Value1 is empty then ForcedValue = Value2.
If Value1 containes a value then ForcedVaue = Value1.
Below my solution, let me know what do you think about it and how can I enhance it.
I am also concerned by performance, because my example containes only 3 records, but in reality I will have millions of records to treat.