Skip routine in transformation

[Former Member]

Hello,

I do have a problem with a transformation from different relations and one source field to different target fields.

In the target is only one key. The problem is that I only want to change the relevant fields in the target dataset when I get deltas and don't want to write initials.

Relations (Source)

RELNr.-BP1

---

BP2-----Rel.Type

1--

---

4711---8000----partner

2--

---

4711---8500----mother

3--

---

4711---9000----father

4--

---

4711---9500----brother

The relations should lead to the following record

BP Table (Target)

BP1----mother-fatherbrother---partner

4711---8500

---

9000-9500--

---

8000

If I test the relationtype per routine and write BP2 to the relevant field the other target fields are written with the value initial. The last record of the datasource wins.

BP--

---

motherfather---brother partner

4711--

---

X

---

X

---

9500---X---

I could handle the problem with an end routine when i use a full DTP. Unfortuanaly I need to load only deltas. How can I skip a routine (not a record) in a transformation to not change the target field?

The result should work like this:

Delta

1--

---

4711---9999-----partner

actual

BP-----mother-father-brother-partner

4711---9500-9000-9500---8000

result

4711---8500-9000-9500---9999

thanks for your help

best regards

Martin

[Former Member · Accepted solution]

Hi Martin,

what you want to achieve can only be implemented in the extractor already. For each record you get (initial or delta load) you need to add the relations as well.

regards

Siggi

[Former Member · Accepted solution]

Hi Siggi,

Thank you very much for your fast reply. Do you have a short "how-to" for adding all relations to the record or to extend the extractor this way?

thanks for your support

Martin

[Former Member · Accepted solution]

Hi,

well unfortunately not, but you can search for that in the forums. But anyway here a short description:

enhance your extract structure so that it contains all necessary fields.

In the appropriate user exit, select all fields not contained in the record.

post the enhanced record to the communication structure and do the mapping.

post the records to your data target.

regards

Siggi