community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Column data into rows (with a limit on number of records in each column)

Asteroid

Hello Community. As a newbie, I've tried the basic table tool, cross tab tool, render tool, and transpose tool, but am stuck.

 

Current output looks like this:

 

Group 1
Pumpkin pie
Gravy
Mashed Potatoes
 
Group 2
Salad
Rolls
Wine
 
Group 3
Sweet potatoes
Cranberries
Stuffing

 

Goal is this:

 

Group 1
Pumpkin pie, Gravy, Mashed Potatoes etc. through #9
more, more, more, through #18
more, more, more, through #27
 
Group 2
Salad, Rolls, Wine etc. through #9
more, more, more, through #18
more, more, more, through #27

 

 

BUT each group includes ~50 records and I need to format this so there are only 9 records per row (each row is only one column) and do not want each value in a separate column. Do you have any recommendations? Thank you!

 

Highlighted
Pulsar

Here is the sample logic for your case.  Share the complete sample data in excel sheet for any further help. 

 

workflow.PNGWorkflowResults.PNGResults

Asteroid

Wow! You are awesome. Thank you.

 

SO close! I must be doing something wrong because my output is not quite right, it's repeating the data in each row and putting new records in row 6, 12, 18, etc.

 

RecordIDRowNoConcat_Plan_number2
10'1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01'
11'1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01'
12'1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01'
13'1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01'
14'1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01','1260459-01'
15'1260459-01','1260459-01','1260459-01','1260459-01','1260459-01'
26'1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01'
27'1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01'
28'1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01'
29'1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01'
210'1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01','1260490-01'
211'1260490-01','1260490-01','1260490-01','1260490-01','1260490-01'
312'1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01'
313'1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01'
314'1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01'
315'1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01'
316'1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01','1260491-01'
317'1260491-01','1260491-01','1260491-01','1260491-01','1260491-01'
418'333932-01','333932-01','333932-01','333932-01','333932-01','333932-01','333932-01','333932-01','333932-01'

If I am understanding what you are wanting correctly (i.e. just capture first 9 rows)

 

You can use a Sample tool to do this. In First N Rows mode, it will truncate the data after a set number of rows.

Pulsar

Possible to share sample source data with workflow?

Asteroid

Hi! Actually, I want each row to include 9 values, but want all rows to be populated (not sampled.) So, I want it to look exactly like Ponraj's image, but need my data in the concat_dummay column. Thank you!

Asteroid

Sure! Thanks SO much for your help.

Asteroid

Here's a sample data file. Thank you!

Sorry I had misunderstood the problem.

 

I suggest:

2018-11-23_18-30-00.png

The multi row formula controls number of items in each line and is set to reset every change in 'Database'

2018-11-23_18-33-08.png

 

The multi field formula converts from the fractional value to an integer and change the type of the row

2018-11-23_18-33-22.png

 

Finally as per @ponraj solution you can use a summarise to make all 9 values appear in a comma separated list

Asteroid

Wow! Thank you SO much for sharing your expertise. This is awesome. I really appreciate your help and can't thank you both enough.

 

 

Labels