Hello, I have a table which contain sequenceID , Minutes and Running sum of Minutes. I want to add a row, - when Running sum of minutes greater than 20,40,60,80 ... (after each multiples of 20) How can I do this in Alteryx Sample data SeqDuration(inMins)RunTot_Duration(inMins)14.5221724894.52217248921.5996800646.12185255331.5996800647.72153261741.5996800649.32121268151.59968006410.9208927461.59968006412.5205728174.81442173117.3349945483.23012320620.5651177598.72699306329.29211081106.15E-0229.35363696110.95365542330.30729239120.39992001630.7072124135.61992216936.32713457142.95325550339.28039008153.90691092643.187301161.55353544744.74083645171.58333333346.32416978185.55839601351.88256579199.72113269761.60369849201.23052312662.83422162214.72779290367.56201452220.21534154767.77735607231.16666666768.94402273244.29710980973.24113254253.68184824676.92298079263.65108516880.57406596274.14329441884.71736037

Adding a row after certain condition met

tjamal1

Hello,

I have a table which contain sequenceID , Minutes and Running sum of Minutes.

I want to add a row,

- when Running sum of minutes greater than 20,40,60,80 ... (after each multiples of 20)

How can I do this in Alteryx

Sample data

Seq	Duration(inMins)	RunTot_Duration(inMins)
1	4.522172489	4.522172489
2	1.599680064	6.121852553
3	1.599680064	7.721532617
4	1.599680064	9.321212681
5	1.599680064	10.92089274
6	1.599680064	12.52057281
7	4.814421731	17.33499454
8	3.230123206	20.56511775
9	8.726993063	29.29211081
10	6.15E-02	29.35363696
11	0.953655423	30.30729239
12	0.399920016	30.7072124
13	5.619922169	36.32713457
14	2.953255503	39.28039008
15	3.906910926	43.187301
16	1.553535447	44.74083645
17	1.583333333	46.32416978
18	5.558396013	51.88256579
19	9.721132697	61.60369849
20	1.230523126	62.83422162
21	4.727792903	67.56201452
22	0.215341547	67.77735607
23	1.166666667	68.94402273
24	4.297109809	73.24113254
25	3.681848246	76.92298079
26	3.651085168	80.57406596
27	4.143294418	84.71736037

Preparation

Accepted answers

cgoodman

Do you want this new row to contain any data or just to be blank?

How I would approach this is to use the tile tool. With this tool there is a configuration to set manual values as your cut offs, so this would be 20,40,60 etc. This will then create two new fields called Tile_Num and Tile_Seq which can later be used to sort your data.

Next you need to create a fake row, so using the summarize tool you can group by Tile_num and get the max for your Tile_seq. Using a formula tool you can increase the max tile sequence value by 1. Unioning this data with your original data and then sorting will insert the blank rows where you want them.