Hi folks I have this table:
and trying to simplify it so I can get to this:
Any help greatly appreciated.
Omar
Solved
Simplifying a Table
+1Best answer by david_r
Here's one way to do it, I'm sure there are others:
- ListPopulator with prefix set to "Segment", list name as "SegmentID"
- ListExploder on list "SegmentID{}"
Send the attributes "ReportID" and "SegmentID" to your writer
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 8394 replies
- Best Answer
Here's one way to do it, I'm sure there are others:
- ListPopulator with prefix set to "Segment", list name as "SegmentID"
- ListExploder on list "SegmentID{}"
Send the attributes "ReportID" and "SegmentID" to your writer
+20- Safer
- 3719 replies
What is the source format? I'm a bit concerned that the reader will be a bit confused at having several columns with the same name. I checked and the CSV reader will add a suffix to duplicated column names so that is a way in. And then @david_r's technique works swimmingly.
- 8394 replies
What is the source format? I'm a bit concerned that the reader will be a bit confused at having several columns with the same name. I checked and the CSV reader will add a suffix to duplicated column names so that is a way in. And then @david_r's technique works swimmingly.
Segment
Segment00
Segment01
Segment02
Segment03
...Thanks @david_r
Once again FME delivering brilliant support, I really like this product and the community!
As an aside, I was getting a lot of `MISSING_PARAMETER_LIST' rejections on the ListExpldoer as my lists were not all the same length and contained missing records. I realised that by importing the CSV and reading blank cells as 'NULL' rather than 'missing' I was not getting any `MISSING_PARAMETER_LIST'. on my ListExploder.
Once I exploded the list I filtered out the NULL records.
This is the value I set in the reader.
- 8394 replies
Thanks @david_r
Once again FME delivering brilliant support, I really like this product and the community!
As an aside, I was getting a lot of `MISSING_PARAMETER_LIST' rejections on the ListExpldoer as my lists were not all the same length and contained missing records. I realised that by importing the CSV and reading blank cells as 'NULL' rather than 'missing' I was not getting any `MISSING_PARAMETER_LIST'. on my ListExploder.
Once I exploded the list I filtered out the NULL records.
This is the value I set in the reader.