Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Transpose rows to (variable) columns

More
12 years 6 days ago #2221 by Gennaro
Transpose rows to (variable) columns was created by Gennaro
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 to join the conversation.

More
12 years 6 days ago #2222 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Transpose rows to (variable) columns
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


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.
Attachments:

Please Log in to join the conversation.

More
12 years 6 days ago #2224 by Gennaro
Replied by Gennaro on topic Re:Transpose rows to (variable) columns
thanks a lot!

Please Log in to join the conversation.

Time to create page: 0.271 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.