Denormalization use case

@timotheebecker​ Try the Aggregator transformer. Use Group By for the Building ID and then Attribute to Concatenate

Thank you very much @Mark Stoakes​ !

As it seems a little complex, I've tried simplifying the problem to move forward. But there's still something I'm not able to do.

I try treating the cases grouped by TIME. So for 1 ORIGIN, the columns to create are as follow :

And for INTERMEDIATE, it would be the same columns but replacing ORIGIN by INTERMEDIATE.

As there are two sets of values for INTERMEDIATE, I need concatenation. Whild my test works without concatenation, it doesn't work when concatenation is needed.

Here attached is my workbench and sample data. Could you have a look please ?

Cheers,

Tim

@timotheebecker​ Not quite a transpose problem. I'm not sure if the attached gives you exactly what you need, but hopefully it gives you some ideas. I'm sure there is a more elegant approach - perhaps a simple Python script.

Thank you !

That works a charm !

For others interested, the key transformers here are

• AttributeFilter
• Aggregator
• AttributeRenamer

Here attached is my final testcase.

And here's a screenshot of it.

Thanks a ton ! @Mark Stoakes​