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.
  • Page:
  • 1

TOPIC: Transpose rows to (variable) columns

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

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Junior Member
  • 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:

Please Log in or Create an account to join the conversation.

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 242
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:

Please Log in or Create an account to join the conversation.

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.

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

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 25
thanks a lot!

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.091 seconds