Data360 Analyze

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

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  how should I get the last day record?

    Employee
    Posted 01-02-2020 20:55

    Hi, guys, how should I get the last day's record(2019/1/9), only split this record from the input, the excel will append one day's record everyday, I just want the last day in the excel, it's not a fixed date. I test the transform node with regex, but not work, please help, thanks



  • 2.  RE: how should I get the last day record?

    Employee
    Posted 01-03-2020 05:28

    If the record you want is always the row above the one containing 'total' and there are no rows after the 'total' row then you can use the Tail node configured to output the last two records and then use the Head node to only output the first of those two records.



  • 3.  RE: how should I get the last day record?

    Employee
    Posted 01-05-2020 19:05

    ok, got it, thanks very much, Williams