Skip to Content
avatar image
Former Member

Getting eariest date from item lines

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 23, 2007 at 01:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2007 at 11:14 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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 ********