Avatar

Ron Li

  • Total activity 25
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 9

Activity overview

Latest activity by Ron Li
  • Avatar

    Ron Li created a post,

    Unicode data can't change to double

    I would like to change a field from unicode to double type.  Previous run is fine, but this problem occur after serveral runs. It's a comma values , e.g. 1,234,567.89  Thanks for helping.

  • Avatar

    Ron Li commented,

    Thanks Gerry and Adrian! Ya, I find that Data360 Analyze v.3.5.1 has the path safe properties for timestamp. However, I have to stick to v.3.5.0 for enterprise purpose. Regarding Gerry solution, it...

  • Avatar

    Ron Li commented,

    Thank Adrian for your prompt and detailed solutions. Ya, the Output Excel using template files work perfectly in most scenarios regarding formatting.

  • Avatar

    Ron Li created a post,

    Pivot Table with no column specified

    Currently, I am trying to micmic the pivot table generated in Excel. Example: Input data: ID     FRUIT        NUM     PRICE ------------------------------------------------ 1      APPLE            ...

  • Avatar

    Ron Li created a post,

    Output file with customized timestamp

    In File property, I understand we can specify the runtime timestamp via Property References --> run properties --> CurrentDateTime. How can I format this timestamp? By default is yyyy-MM-dd HH:mm:s...

  • Avatar

    Ron Li commented,

    Hi Thomas,   I encountered the same problem and it can be easily solved by using the "Modify Fields" Node. You may indicate the Format for different fields in "Modify Fields" Node, following the ...

  • Avatar

    Ron Li commented,

    Thanks Adrian, you are right. I should split the file separately, then continue on manipulation. Thank you for your advice.

  • Avatar

    Ron Li created a post,

    About looping and aggregating across rows

    1. Looping : Is there a way to read in a file one by one and do manipulation? I want to be dynamic because the number of files is unknown. 2. Aggregating across rows : Is there a way to perform thi...

  • Avatar

    Ron Li commented,

    Thank you for your help, I have used merge to find the matched records:)

  • Avatar

    Ron Li commented,

    thank you for your response. Could I also specify a row's first field name so that I can filter out dedicated rows as output? Like I just want these two rows from file A.  If I specify fields['Appl...