Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Transpose rows to (variable) columns

Transpose rows to (variable) columns 4 years 8 months ago #2221

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
Hello,
is there way to group and to transpose the rows to varaible columns? The rows as well as the columns can be variable.

please, see below a simple example:



thanks for your software and support!


regards

Attachment example-20120321.zip not found

Attachments:
The administrator has disabled public write access.

Re:Transpose rows to (variable) columns 4 years 8 months ago #2222

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Gennaro,

You can do that with the help of the GroupBy Heater and for each (row) column you need one IF-THEN-ELSE Heater to decide which content you want to store in which column on the WRITE side.

For the condition you need one additional AutoID Heater. The Heater counts per each group from 1 to how often the same Code (group) is available. For each column you need a condition like this.

= 1 = for the first read row = the first write column
= 2 = for the second read row = the second write column

I've made a brief example (rows to columns) based on your example data; please have a look to the attachment.

Attachment rows_to_columns-20120321.zip not found

Attachments:
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.

Re:Transpose rows to (variable) columns 4 years 8 months ago #2224

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
thanks a lot!
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.077 seconds