Row data eg: a b 10
Expected eg:
col1 col2 col3 col4
a b 10 30
a b 10 60
a b 10 90
a b 10 120
a b 10 150
I don’t think you’ve provided enough information here.
You ask about duplicating whole rows, but your example results table doesn’t show any duplicates.
How is x being decided?
Where is the data in column 4 coming from?
2 Likes
I am looking to add new column with range 30, 60… 360 and for number generated add rows with same value.
Here range is 30~150 pattern i.e 5 rows
I am looking to add new column with range 30, 60… 360
Does this mean that you will always have at most 12 rows?
Here range is 30~150 pattern i.e 5 rows
Where is this coming from? How is this being decided?
yes for this case
Range is upto 360 so there can be case where it starts from 10,20,30…upto 360 in that case those many rows
If you have the row you want to “duplicate”
And the numbers you want to add
You can use a cross joiner node to get here:
6 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.