KRana
September 19, 2016, 3:56pm
1
Hello,
I have data like below, i need to create row based on two columns data.
Year
Min_value
Max_value
2004
1
6
2005
3
5
2006
-1
7
2011
-2
671
2016
148
5766
so here i need a column start with "1" for every year upto it reaches to Max_value like below.
Year
Min_value
MAx_value
Rowcount
2004
1
6
1
2004
1
6
2
2004
1
6
3
2004
1
6
4
2004
1
6
5
2004
1
6
6
2005
3
5
1
2005
3
5
2
2005
3
5
3
2005
3
5
4
2005
3
5
5
2006
-1
7
1
2006
-1
7
2
2006
-1
7
3
2006
-1
7
4
Please help me out.
Thanks in advance.
hornm
September 21, 2016, 5:06pm
2
Hi,
I attached a workflow that hopefully does what you were asking for. It uses two nested loops and is therefor probably not the most efficient solution (but I couldn't come up with another).
Best, Martin
If you're worried about using nested loops, here are three approaches that don't require it.
- first with an implicit loop inside a java snippet, tidiest looking
- second using one group loop
- third without any loops but potentially costly as it requires a cross-join
Best
David
hornm
September 26, 2016, 3:00pm
4
Yet another solution - with just two nodes ;)