Forum Discussion
Solved
Create a column with a repeating sequence
Hi everyone, Currently, I have a column that contains distinct values, as such: 10007 7249 59 7882 11005 I would like to add another column of a repeating sequence, for each...
Ori_I13 ,
The CROSSJOIN function will work for you:
ValuesNew = CROSSJOIN( 'Values', UNION( ROW("Sequence", 2023), ROW("Sequence", 2024), ROW("Sequence", 2025)))'Values' is the name of your first table.
You can replace the UNION part with the name of a second table if you have many more values than the 3 you have shown in your example.
Regards,
Ori_I13 ,
The CROSSJOIN function will work for you:
ValuesNew = CROSSJOIN( 'Values',
UNION(
ROW("Sequence", 2023),
ROW("Sequence", 2024),
ROW("Sequence", 2025)))'Values' is the name of your first table.
You can replace the UNION part with the name of a second table if you have many more values than the 3 you have shown in your example.
Regards,
Thank you very much!
Worked like a charm
