I'm new in the community and tried as much as possible to find an existing answer, however my problem might be too specific.
I have a dataset, in which values are recorded over time every 10 minutes (13:40,13:50,....)
In a second dataset I have alert entries which have an exact time stamp (exact in minutes: e.g. 09:32,11:48,..).
In order to match the alert entries to the regular time records to highlight when values in the first dataset have been impacted by an alert, I might need to add additional rows to the first dataset. Specifically: 9 rows, in between the 10-minute-records and fill these added rows with a time-stamp by minute. (Currently:13:40;13:50 Target: 13:40,13:41,13:42,...13:50)
However, I don't know if I might need to code this, or if there is another way to automatically add 9 rows between two existing rows (dataset has more than 20,000 rows).
If you have questions, since it's not specific enough, please let me know.
Kind regards,and thanks for any help in advance.
Sorry for delay!
We are working on your issue and then come back to you as soon as we can.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.