transform NTE segments into additional OBX segments

Question

Question

Krzysztof Maik · Oct 1, 2019

hi

A newbie question. I am trying to use Data Transformation Editor to transform NTE segments into additional OBX segments. At the moment I am getting both segments OBX and NTE trying to populate a single OBX. Can this be easily fixed?

Discussion (4)1

Log in or sign up to continue

Robert Hanna · Oct 1, 2019

Ok got it, so your DTL is currently setting the last NTE to the OBX. To have individual OBXs for each NTE plus the original OBX you need to put in a for loop to process each one of the NTEs into a new OBX. Something along the lines of this:

Quickly tested on my system:

0 0

score 0 · Answer 1 · 2019-10-01T10:11:55-04:00

Hey Krzysztof,

Is the create type for the DTL new or copy? If it is copy, you probably need to also add in a remove action for the NTE(s) that you don't want.

score 0 · Answer 2 · 2019-10-01T11:35:47-04:00

Krzysztof Maik · Oct 1, 2019

Brilliant. It is working.

Thank you.

Much appreciated.

0 0

score 0 · Answer 3 · 2019-10-01T10:24:25-04:00

Hi

Thank you for your comment. At the moment it is set to New. This is the output when I test it. NTE segment is no longer there which is what I wanted but I am not getting additional OBX lines.