Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

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

Highlighted
8 - 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
13 - Pulsar

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

 

WorkflowWorkflowResultsResults

Highlighted
8 - 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'
Highlighted
16 - Nebula
16 - Nebula

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.

Highlighted
13 - Pulsar

Possible to share sample source data with workflow?

Highlighted
8 - 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!

Highlighted
8 - Asteroid

Sure! Thanks SO much for your help.

Highlighted
8 - Asteroid

Here's a sample data file. Thank you!

Highlighted
16 - Nebula
16 - Nebula

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

Highlighted
8 - 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