VERY VERY Urgent help required Please

[Swaraj8565]

Hi 

This is a cohort chart the repetition depends on the divide number 

Attached the Image of the workflow.

Product	Divide		Jan	Feb	March	Apr
A	2	Jan	1
A	2	Feb	1	2
A	2	Mar		2	3
A	2	Apr			3	4

Very urgently required please help

Input table is 

Product	Divide	Jan	Feb	Mar	Apr
A	2	1	2	3	4

Hoping for a best possible earliest response

DELETE

• View all messages
• Next 

[Rajsekhar8917]

@cplewis90 

@DavidP 

@danilang 

Hey Ace experts

please help I also need a solution for this 

Please

[huynv96]

Hope this help you!

[Swaraj8565]

Hey 

First of all thanks for the solution but it didnot work

It only worked for divide number 2 

lets take for number 4 it should be like

INPUT:

Product	Divide	Jan	Feb	mar	Apr
A	4	1	2	3	4

output should be 

Product	Divide	Jan	Feb	mar	Apr
A	4	1
A	4	1	2
A	4	1	2	3
A	4	1	2	3	4
A	4		2	3	4
A	4			3	4
A	4				4

[huynv96]

Hi, @Swaraj8565 

Do you mean Output:

Input:

[Swaraj8565]

Hey

Check your values in jan column it should be repeated 4 times where as your value is repeated 2 times please check the output whichnI am sending with your output image

Hey 

First of all thanks for the solution but it didnot work

It only worked for divide number 2 

lets take for number 4 it should be like

INPUT:

Product	Divide	Jan	Feb	mar	Apr
A	4	1	2	3	4

output should be 

Product	Divide	Jan	Feb	mar	Apr
A	4	1
A	4	1	2
A	4	1	2	3
A	4	1	2	3	4
A	4		2	3	4
A	4			3	4
A	4				4

[Swaraj8565]

Hey 

the solution Still  did not work

It only worked for divide number 2 

lets take for number 4 it should be like

it should be repeated for divide number times

INPUT:

Product	Divide	Jan	Feb	mar	Apr
A	4	1	2	3	4
B	3	1	2	3	4
C	2	1	2	3	4

output should be 

Product	Divide	Jan	Feb	mar	Apr
A	4	1
A	4	1	2
A	4	1	2	3
A	4	1	2	3	4
A	4		2	3	4
A	4			3	4
A	4				4
B	3	1
B	3	1	2
B	3	1	2	3
B	3		2	3	4
B	3			3	4
B	3				4
C	2	1
C	2	1	2
C	2		2	3
C	2			3	4
c	2				4

[danilang]

Hi @Swaraj8565, @Rajsekhar8917  

It's interesting that both of you have exactly the same problem.  Are your assignments due tonight?  Since it looks like this is a learning exercise that you should be doing yourselves, I'll give you a couple of big hints.  

Hint #1. This workflow is dynamic and will work for any number of rows and values of [Divide]

Hint #2

The heart of the workflow is the Generate rows that determines the final number of rows in the output using OutputRow <= [Divide]+[Count]-1 and then the Formula removes the proper value using the following 

If [OutputRow]>[RecordID]-1 AND [OutputRow]<[Divide]+[RecordID] then
	[Value]
else
	null()
endif

I'll leave it to both of you to determine the configuration of the remaining tools

Dan

[huynv96]

Your expectation

[Swaraj8565]

Hey

First of all thanks for the response 

Me and the other guy dont know each other and this is not an assignment 

This is a project of cohort

Nowadays we need the use of cohort everywhere

I would request you to kindly give me the solution instead 

as it looks to be easy while explaining but if we do the workflow I am sure It wont work out

I am banging my head since 3 weeks around this 

and I hope this would be helpful to every one as this type of problems arise every where

and even I dont have the Idea of macro

Henceforth I would request you to help me out with the solution beacause I have tried a lot of methods to work this out but all are in vain

Regards 

Swaraj