Skip to Content
0
Apr 11, 2013 at 12:19 PM

Management of Dat between 2 tables

23 Views

Hi experts,

In BW, i have 2 tables:

Table 1:

Account

YesNo

Value1

A1

No

A2

Yes

A3

Yes

ABC

Table 2:

Account

Value2

ForcedValue

A1

XXX

A2

YYY

A3

ZZZ

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.

Thanks.

Amine