Skip to main content
  • EN

Can't wrap my head around the following reformatting problem. My data looks like this:

Pointid substance1 substance2 substance3...

1 value

2

3

I have a lot of columns in the original data, almost 200 different substances. I would like to achieve the following structure (below) where Substances attribute contains all values of 200 substance columns and is exploded for each Pointid. So basically every Pointid is replicated for each substance and values column have the value of each substance. I've tried multiple combinations of transformers but without result.

Pointid Substances values

1 Substance1 value

1 Substance2 ...

1 Substance3

2 Substance1

2 Substance2

...

I think you can solve this with an AttributeExploder.

I think you can solve this with an AttributeExploder.

Attached sample workspace.

AttributeExploderSample

Hi @japeki​ , alternatively you can use the ListPolulator to populate all the values of Substance* attributes into a list attribute.

listpopulator-example 

Attached sample workspace.

AttributeExploderSample

This seemed to work thank you! I've tried AttributeExploder before but somehow didn't get the same result.

Reply


Community Stats

30,171
Posts
114,537
Replies
37,834
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.