Skip to main content
  • EN

I’m trying to output all property sets from IFC files into separate Excel sheets. So far I’ve found all of the property sets, their attributes and their attribute values. 

This is my data:

What I would like to do is transpose this list into separate lists for each property set like so:
 

After that I could simply write each list to separate Excel sheets, but this is where I get stuck. I create the sheets by feeding the writer from a DuplicateFilter, but how do I join each PsetAttribute to Pset as well as transpose the data so each PsetAttribute is a single column?

I need to do it without knowing the exact names or number of property sets existing in each IFC file as well.

I don’t know if you want to try generating a CSV for this instead. I’m not sure how to dynamically rename columns in excel otherwise. I am able to group the values in the way that I think you are asking. I assumed in my workspace that you can group by filename for each row. I used the exact input you showed only in your screenshot. So my output is incomplete, but it would work on complete data the same. I hope this is decipherable. This is not the prettiest workspace, but it might help you to get closer to what you want.

First I am determining the columns needed, then I get values for all possible cells, then I aggregate rows. It might be easier to do some steps using Python, but I decided to go this way. I’ve attached the template workspace I used with the csv input I used.

 

 

 

 

I don’t know if you want to try generating a CSV for this instead. I’m not sure how to dynamically rename columns in excel otherwise. I am able to group the values in the way that I think you are asking. I assumed in my workspace that you can group by filename for each row. I used the exact input you showed only in your screenshot. So my output is incomplete, but it would work on complete data the same. I hope this is decipherable. This is not the prettiest workspace, but it might help you to get closer to what you want.

First I am determining the columns needed, then I get values for all possible cells, then I aggregate rows. It might be easier to do some steps using Python, but I decided to go this way. I’ve attached the template workspace I used with the csv input I used.

 

 

 

 

Thank you! When I open your workspace it’s telling me I don’t have the versions of Duplicate Filter and Feature Merger you used. Could you attach summaries to those transformers so I can add them manually?

Absolutely! I hope this helps. In the feature merger, I merged every feature. I’ve attached a screenshot with all of the summary annotations for the feature merger and the duplicate filters.

 

Absolutely! I hope this helps. In the feature merger, I merged every feature. I’ve attached a screenshot with all of the summary annotations for the feature merger and the duplicate filters.

 

Finally had the chance to look at this. Learned a lot from studying how you did this, never even considered the benefints of using csv here. 

 

Thank you very much!

Reply


Community Stats

30,815
Posts
116,804
Replies
38,641
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.