Skip to main content
Open

ListExploder to work with irregular lists

Related products:Transformers
  • June 6, 2016
  • 4 replies
  • 157 views

jdh
Contributor
Forum|alt.badge.img+40

It would be nice if the ListExploder could work with irregular lists instead of rejecting them with fme_rejection_code' has value `MISSING_PARAMETER_LIST'.

An irregular list is a list that either does not start at 0 or does not have continuous indexes.

ex.
_list{1}
_list{2}
_list{3}

or
_list{0}
_list{2}
_list{3}
_list{5}

4 replies

  • November 30, 2016

+1 for this suggestion

As a workaround I tried listCopier but the irregular indexes were copied along. However applying a ListSorter using an arbitrary list attribute and than applying the list exploder actually didn't result in the MISSING_PARAMETER_LIST error any longer.

Sorting of course has its performance cost, so it would be good to foresee a solution within the listExploder transformer.


Forum|alt.badge.img+1
  • September 5, 2017

I had the same problem, I was reading from a CSV, and building lists from it, 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.

Forum|alt.badge.img+1
  • September 5, 2017

'

This is the value I set in the CSV reader.

stezi
Contributor
Forum|alt.badge.img+6
  • Contributor
  • October 28, 2022

Fantastic! Thanks