LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Data analyzer

    Employee
    Posted 08-10-2010 00:47

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: eman

    how to change the o/p fields of the data analyzer ?
    How to deal with date"if I want the records which due date >1-1-2010 and <1-15-2010 for ex" ?


  • 2.  RE: Data analyzer

    Employee
    Posted 08-13-2010 11:39

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    I am not sure I understand the question...the data analyzer will give you three output pins, and the top one should be the converted data, if it determines the data can be converted. The middle pin will give you information about each of the fields, and what it found for new types, among other information.

    As to your statement:

    How to deal with date"if I want the records which due date >1-1-2010 and <1-15-2010 for ex" ?

    I am not sure I follow. Are you saying you have records that have a dueDate field, and you want to deal with only them? If so, you would convert the dueDate field to a date, and then you can put a split down, and have the expression:

    dueDate > "2010-1-1".date("CCYY-M-D") and
    dueDate < "2010-1-15".date("CCYY-M-D")

    You have to do the conversion on the strings, as "2010-1-1" is just a string, and you can't compare to a date until you convert it.

    If I misunderstood, and you mean the dates themselves are in a string field, embedded with text, that is different question, and you will want to do pattern extraction to pull them out. I or someone else can cover that, but I don't think that was your question.


    Cheers
    Rich