Crosstab records based on column names

aysha6029

Hi Friends,

I want to Crosstab every 10 records based on column names.. pls help me with the workflow to achieve the solution.

Workflow

Transformation

Accepted answers

DultonM

Hi aysha6029,

Great data blending question! I assume you want your data to end up like this:

Name	Address	Telephone
Hike	Gravette	444555666
Mike	Granite	22288877

If so, there's a simple solution! All you need to do is add a Multi-Row formula tool before the Crosstab tool. I attached a workflow that demonstrates the answer.

Capture (3).PNG

The Multi-Row Formula is used to create a new field called Counter. Each time "Name" appears, the counter goes up by 1. So your table data will become:

Field1	Field2	Counter
Name	Hike	1
Address	Gravette	1
Telephone	444555666	1
Name	Mike	2
Address	Granite	2
Telephone	22288877	2
Name	Hancock	3

Here's the Multi-Row Formula's configuration:

You can now Crosstab this data grouping on the Counter. Here's the configuration

Capture (2).PNG

Tada! Let me know if you have any questions! Please mark if this solves your question!

Thank you,

DultonM

Crosstab records based on column names.yxmd

aysha6029

Thank You. Its working

All comments

aysha6029

Hi Friends,

I ll give an example of my problem. i want to cross tab te below table using the column name.. pls help me on how to do this.

Name	Hike
Address	Gravette
Telephone	444555666
Name	Mike
Address	Granite
Telephone	22288877
Name	Hancock

DultonM

Hi aysha6029,

Great data blending question! I assume you want your data to end up like this:

Name	Address	Telephone
Hike	Gravette	444555666
Mike	Granite	22288877

If so, there's a simple solution! All you need to do is add a Multi-Row formula tool before the Crosstab tool. I attached a workflow that demonstrates the answer.

Capture (3).PNG

The Multi-Row Formula is used to create a new field called Counter. Each time "Name" appears, the counter goes up by 1. So your table data will become:

Field1	Field2	Counter
Name	Hike	1
Address	Gravette	1
Telephone	444555666	1
Name	Mike	2
Address	Granite	2
Telephone	22288877	2
Name	Hancock	3

Here's the Multi-Row Formula's configuration:

You can now Crosstab this data grouping on the Counter. Here's the configuration

Capture (2).PNG

Tada! Let me know if you have any questions! Please mark if this solves your question!

Thank you,

DultonM

Crosstab records based on column names.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703