I am trying to use the "Rows to Columns" node from the "Actian Dataflow" extension, but I cannot make it work for some reason. Has anyone used that node before? I would appreciate a working example.
These are some of the problems I encountered:
1. I don't know what to put in the "aggregations" field. I tried min(<field>), max, avg, etc., but without any success.
2. In the "Pivot key" field I get ALL string fields available and I couldn't find an easy way to select only one of them. I can control it by passing a flow variable, but I was hoping for a more elegant solution.