Process the Column data in Excel File

[new_pentaho_user]

We are receiving the data in excel file and need to insert into the database. Please find the input file format and the expected output.

Could you please provide inputs and really helpful

Input:

TimeStamp	FieldA	FieldB
2017-01-01T00:00	0.0	0.0
2017-01-01T00:30	0.0	0.0
2017-01-01T01:00	0.0	0.0
2017-01-01T01:30	0.0	0.0
2017-01-01T02:00	0.0	0.0
2017-01-01T02:30	0.0	0.0
2017-01-01T03:00	0.0	0.0
2017-01-01T03:30	0.0	0.0
2017-01-01T04:00	0.0	0.0
2017-01-01T04:30	0.0	0.0
2017-01-01T05:00	0.0	0.0
2017-01-01T05:30	0.0	0.0
2017-01-01T06:00	0.0	0.0
2017-01-01T06:30	0.0	0.0

Expected Output:

FieldName	TimeStamp	Value
FieldA	2017-01-01T00:00	0.0
FieldA	2017-01-01T00:30	0.0
FieldA	2017-01-01T01:00	0.0
FieldA	2017-01-01T01:30	0.0
FieldA	2017-01-01T02:00	0.0
FieldA	2017-01-01T02:30	0.0
FieldA	2017-01-01T03:00	0.0
FieldA	2017-01-01T03:30	0.0
FieldA	2017-01-01T04:00	0.0
FieldA	2017-01-01T04:30	0.0
FieldA	2017-01-01T05:00	0.0
FieldA	2017-01-01T05:30	0.0
FieldA	2017-01-01T06:00	0.0
FieldA	2017-01-01T06:30	0.0
FieldB	2017-01-01T00:00	0.0
FieldB	2017-01-01T00:30	0.0
FieldB	2017-01-01T01:00	0.0
FieldB	2017-01-01T01:30	0.0
FieldB	2017-01-01T02:00	0.0
FieldB	2017-01-01T02:30	0.0
FieldB	2017-01-01T03:00	0.0
FieldB	2017-01-01T03:30	0.0
FieldB	2017-01-01T04:00	0.0
FieldB	2017-01-01T04:30	0.0
FieldB	2017-01-01T05:00	0.0
FieldB	2017-01-01T05:30	0.0
FieldB	2017-01-01T06:00	0.0
FieldB	2017-01-01T06:30	0.0

[new_pentaho_user]

I have used Row Normalizer and got the output as expected

[Sparkles]

Classic ETL example. Well done.