selecting line item from multiple source data

[Former Member]

Hi Folks,

My scenario is to get the 2nd and 3rd line item.

SUPPRESS

SMO

-context change-

06.12.2007

-context change-

15.12.2007

-context change-

sample

Your advise is very much appreciated.

Thanks a ton!

Lex

[Former Member · Accepted solution]

Hi Lex,

1) I think you have to write UDF.

2) TDLINE --> RemoveContext -->UDF --> SplitByValue(Each Value) --> DTM 02.

3) In UDF take a for loop for TDLINE. don't return value for 1 st instant. return value only for 2nd and 3rd instant of TDLINE. Use if condition for that.

4) Means from UDF only 2nd and 3rd value come out. Which you can map to DTM 02.

I think this will solve your problem.

Regards,

Rohit.

Reward points if helpful.

[Former Member · Accepted solution]

Hi Rohit,

Just to add the scenario will be the following:

2nd line item -

---

> target 01

3rd line item -

---

> target 02

Pretty much, both line items have different target fields.

Regards,

Lex

[Former Member · Accepted solution]

Hi,

1) Create 2 UDFs 1st produce only 2nd line,

2) don't consider 1st, 3rd, lines.

3) Create 2nd UDF which will produce only 3rd line.

try this.

Regards,

Rohit.

Rewards points if helpful.

[Former Member · Accepted solution]

Hi Folks,

Thanks so much for your kind responses.

I managed to resolve the scenario without using a UDF. I filtered the source data using the length function then sort the two values in order to get the 3rd item.

Regards,

Lex