Data360 Analyze

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

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.

ok, got it, thanks very much, Williams