Skip to main content
  • EN

Hello.

I have shapefiles as the source of my data. I have no knowledge of what the attributes in the shapefile are going to be.

 

What I need to do is to create an object (table row) , where for each object(row) I will have only one property and it's value (basically the oposite process of aggregator).

for example - the original (incoming) data are:

id1, property1_value, property2_value, property3_value

id2, property1_value, property2_value, property3_value

What I am trying to get:

id1, property1_name, property1_value

id1, property2_name, property2_value

id1, property3_name, property3_value

id2, property1_name, property1_value

id2, property2_name, property2_value

id2, property3_name, property3_value

Any help would be really appreciated. Thanks,

Radek

How about this?

Rename property1/2/3_name into "prop{i}.value" and create "prop{i}.name" (i = 0, 1, 2).


Then, you can decompose the "prop{}" list with the ListExploder.

How about this?

Rename property1/2/3_name into "prop{i}.value" and create "prop{i}.name" (i = 0, 1, 2).


Then, you can decompose the "prop{}" list with the ListExploder.

Good answer, however I am not good with loops and scripting - there are going to be many more attributes, and I have no idea the exact number.

 

I have found a solution - use AttributeExploder followed by AttributeKeeper and id does exactly what I needed.

Thanks!

Reply


Community Stats

30,112
Posts
114,303
Replies
37,745
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.