Getting Data In

Time stamp field using transforms.conf

rsathish47
Contributor

HI All,

Am have CSV which is semicolon as delimiter and am using Props and transpose to extract the fields. But am assigning fields name in the transpose and am not able to set _time field . Please let me know how to do that.

Props.conf

[Jbossorder]
REPORT-formation = split_header
BREAK_ONLY_BEFORE = SO;

transforms.conf
[split_header]
DELIMS = ;
FIELDS =H1,H2,H3,H4,datetime

Thanks
Sathish Rangan

0 Karma
1 Solution

rsathish47
Contributor

I fixed it using props.conf

[Jbossorder]
FIELD_DELIMITER =;
TIME_FORMAT = %Y%m%dT%H%M%S%z
TIMESTAMP_FIELDS = datetime
FIELD_NAMES = H1,H2,H3,H4,datetime

View solution in original post

0 Karma

rsathish47
Contributor

I fixed it using props.conf

[Jbossorder]
FIELD_DELIMITER =;
TIME_FORMAT = %Y%m%dT%H%M%S%z
TIMESTAMP_FIELDS = datetime
FIELD_NAMES = H1,H2,H3,H4,datetime

View solution in original post

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!