how should I get the last day record?

Follow

Frankky

• January 03, 2020 03: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

0

• 

  Adrian Williams

  • January 03, 2020 12:27

  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.

  1

  Comment actions Permalink
• 

  Frankky

  • January 06, 2020 02:04

  ok, got it, thanks very much, Williams

  0

  Comment actions Permalink

Please sign in to leave a comment.