Solved

Decomposing attribute table.

  • 15 February 2016
  • 2 replies
  • 2 views

Badge

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

icon

Best answer by takashi 15 February 2016, 17:31

View original

2 replies

Userlevel 2
Badge +17

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.

Badge

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