+4
Hi,
I’m trying to apply a schema from excel to 2D utility lines so that it applies the schema to the lines and creates 3D pipes of the same size, also adding the metadata.
I have an idea of how to put this together, however am struggling to select the right information from the excel and make it dynamic.
Example: If find ‘water’ in dwg, then apply a 200mm pipe to the center and add ‘water’, metadata1, metadata2 as attributes to the line.
Thanks in advance!
+36
This would be a lot easier if you could 'flip’ your Excel. Is that an option?
| type | size | info1 | info2 | |
|---|---|---|---|---|
| asset1 | Gas | 60 | metatata1 | metadata2 |
| asset2 | Water | 200 | metadata1 | metadata2 |
| asset3 | Electrical | 50 | metadata1 | metadata2 |
+17
I think
It is possible to transpose tables using FME, see this article: https://support.safe.com/s/article/transpose-a-table-using-fme
Also, this is something that has been asked frequently on the forum, here's one example of a solved thread:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
