![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/c1b15a90-1f22-4829-b7ac-1f2e71d12fea.png)
Data comes from a monitor device, with test results of different elements. Those elements have 3 values, their ID, Their Value and any error messages.
The customer wants to see a flattened list of just Monitor Device and timestamp with a result of each element on seperate lines.
- Using the above we can achieve that, we import the data ignoring the header line. (hence labeling them with numbers)
- First we label the monitor “Parent” fields by using a field renamer
- We build a Empty map for us to correctly parse the records using expression evaluator
- we use a field mapping processor, to map those groups of 3 fields ( checking we only remap columns that are numeric)
- now we have groups, we split the groups into records using a field pivot processor
- This leaves a single group per record but as a group, Lets tidy that up with a field flattener so all the records are at the same level
- Finally we use a field renamer to label the 3 fields we have produced
- We ship that off to our secure storage facility…. or as this is a demo, into trash.
A Bit more detail on the field mapper
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/9c24d71e-d7b5-4986-94be-9e84d81ef197.png)
Before
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/1f1130d2-bfb7-4588-82be-ec14bf50e02b.png)
After
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/12b0d942-14a7-4e11-9ea6-8db3a1382300.png)