skip to Main Content

I have a CSV file with attribute name EpochWithMicroSec and value like 1512520846 and I want to append 000 at the end of value like this 1512520846000.

I am using following configuration please help to fix this issue.
TIA

My configuration is appending 000 at the last attribute of my CSV file. How to map it to attribute EpochWithMicroSec attribute?

enter image description here

enter image description here

2

Answers


  1. If you’re only working on the attribute itself, you should use UpdateAttribute rather than ReplaceText (the latter works on the flow file contents, not attributes). In UpdateAttribute you can add a user-defined property “EpochWithMicroSec” with the same Expression you have in your ReplaceText: ${EpochWithMicroSec:append('000')}

    Login or Signup to reply.
  2. As you are changing the existing field value then use

    Replacement Value Strategy

    Literal Value

    Update Record Configs:
    enter image description here

    Add Dynamic property

    /EpochWithMicroSec

    ${field.value:append('000')}
    
    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search