Skip to main content
  • EN

In an excel file, I have 6 checkboxes. In my process, all the value are put in a single list called Method_ID.

 

I have to manage each half in two different way. So I have to put 3 in a second list, and the other 3 in a third list. Because the following process needs a list for the input.

If I use a ListBuilder to make the second list, I can't make the third in another ListBuilder as you can see :

Do I have to use the ListBuilders in parallele? The problem is that I'll have to manage the amount of object later.

Thanks for your help.

Hi @slerendu, the following process requires all of those three lists (6 elements, first 3 elements and last 3 elements)? If the current single list (6 elements) will not be used, consider creating 2 lists from the original Excel row features, without creating 6 elements list.

Hi @slerendu, the following process requires all of those three lists (6 elements, first 3 elements and last 3 elements)? If the current single list (6 elements) will not be used, consider creating 2 lists from the original Excel row features, without creating 6 elements list.

Hi Takashi, yes I need the 6.

 

The problem is that I'm not allowed to change the original extraction.

So you think that make two lists from one list can be done?

OK. The ListSampler from the FME Hub may be a quick way.

  • List Attribute: EXP_DEV_METHOD_ID{}
  • Sampling Type: First N Elements
  • Sampling Amount: 3

With the above setting, the transformer creates two lists (sampled and not sampled) and also preserves the original list.

OK. The ListSampler from the FME Hub may be a quick way.

  • List Attribute: EXP_DEV_METHOD_ID{}
  • Sampling Type: First N Elements
  • Sampling Amount: 3

With the above setting, the transformer creates two lists (sampled and not sampled) and also preserves the original list.

Perfect. Thanks a lot.

Reply


Community Stats

30,353
Posts
115,357
Replies
38,088
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.