copy a value up the number of rows of other columns

Hi;
In the x column, for example, I have a value of 50. I have a single value that comes with the column filter node and I can do how I can add a new column with the number of records from the single incoming value up to the X arm (so I can replicate without change).
X new column (column filter node - received single value)
1 xy
2 xy
3 xy
n … xy

Hi,

Would please explain your question better?
A sample data set and an example of your desired output table will help as well.

Best,
Armin

Hi; Armin
I received a column filter (7111290)
I have to combine it with another column that contains 50 rows of data in another column. But I can’t use column combiner or column appender because the column is the only line that comes with the filter.

I cannot create the colon as a constant value in which the single-line value from the first variable is variable. I have to merge a single-line variable that comes with a column filter to a 50-line column.

@armingrudd
image

How about using a “Table Row to Variable” node after your column filter and then feeding the variable to the “constant value column” node?

1to10

In the configuration window of the Constant Value Column node, go to the “Flow Variables” tab and set the value of the “column-value” to the variable produced by “Table Row to Variable” node.

1to11

Let me know if I’m missing something.

Best,
Armin

3 Likes

Thanks armin;
exactly the solution I need :wink:
you’re super

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.