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?
2
Answers
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')}
As you are changing the existing field value then use
Replacement Value Strategy
Literal Value
Update Record Configs:
Add Dynamic property
/EpochWithMicroSec