Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Empower49
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!

 

9 REPLIES 9
ponraj
13 - Pulsar

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

 

WorkflowWorkflowResultsResults

Empower49
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'
jdunkerley79
ACE Emeritus
ACE Emeritus

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.

ponraj
13 - Pulsar

Possible to share sample source data with workflow?

Empower49
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!

Empower49
8 - Asteroid

Sure! Thanks SO much for your help.

Empower49
8 - Asteroid

Here's a sample data file. Thank you!

jdunkerley79
ACE Emeritus
ACE Emeritus

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

Empower49
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