Hi folks I have this table:
and trying to simplify it so I can get to this:
Any help greatly appreciated.
Omar
Page 1 / 1
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
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.
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.
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.