I am currently using CSV spoolDir to bulk load CSV file into Kafka topics.
Today I wonder if I can combine any SMT with the convert SMT.
CSV records have a Timestamp string field, which I can transform into an INT64 with a SMT.
So far so good.
However I wish to add the Timestamp INT64 convertion to the record as a new field, and not having to convert the original field. Basically I wish to have the original String version field and the new Timestamp converted field.
I though to use the InsertField to “clone” my original field into a new attribute and then use Convert SMT to apply my timestamps convertion, but apparently InserField doesn’t support this operation.
Any idea if is it possible to achieve this using InsertField SMT or any other SMT together ?
Thank you all