Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Multiple operations on one field in updateRecord processor

Highlighted

Multiple operations on one field in updateRecord processor

New Contributor

I have data in such format

01.01.18,14:05:00,person1

Schema is date,time,manager

I want to have this data in such format:

Datetime (contains date and time in iso format), manager

My idea was to use updateRecord

With record path value strategy I configure

Key. Value

/DateTime => Concat(replaceregex(/Date, '(\d{2})\.(\d{2})\.(\d{2})', '20$3-$2-$1'), 'T', /Time, 'Z')

but result is negative. Can somebody help me?