Getting eariest date from item lines

[venky_b]

Hi Experts,

In my scenario,File ->xi->Idoc i want to send file which contain one header and multiple item lines.In the item line there is one field called start date. if there are multiple item lines i want to get the eariest date from item lines and send that date to idoc header. how this can be done.

Regards

venky

[former_member1275317 · Accepted solution]

hi Venkat..

Try this one...

Soruce ---> DateTrans (convert mm-DD-YYY to mmDDYYY) ->removeContexts-> sort (under sort porperties -

---

> Type of Comparison chose NUMERICAL, Order as descending) -

---

> collapseContexts -

---

> Target

regards

Satya

[former_member181959]

Hi,

Generally you would get the first node data among all the item nodes.

May be you can write UDF with context handling by setting the context of the input node to Item node.

Hope this helps. let me know if its not working.

Prasad Babu.

[venky_b]

Hello Prasad,

can you please provide me with the sample UDF for the following requirment

following is my DT:

+ Header

abcd

xyz

+++ Item

++++ start_date

+++ item

++++start_date

The Header has n no of Items in it

Now I want to produce start date to be placed into Header in such a way that the earliest of the start_date is found out and that should be sent into the Header.

Please provide me UDF related to it.

thanks in advane

venkatesh

• useful answers will be rewarded ********