Data360 Analyze

 View Only
  • 1.  Split a record into several lines

    Employee
    Posted 09-16-2019 00:48

    Hello,

    I have a records with a start date and an end date. I want to split it as follows in the transform node:

    The following code is not working:

    count = 0
    while count < NumMonths :
      out1 += in1
      count += 1

     

    I am do not know how to split a record into multiple records.
    I can figure out the start and end date logic by myself. 

    Any suggestions?



  • 2.  RE: Split a record into several lines

    Employee
    Posted 09-23-2019 05:16

    Hi Felix,

     

    You need to explicitly write the output record for each iteration of the while loop using 

    node.write(0, out1)