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,
I know it's been asked a while ago, but I came across this today, and there will be people asking this question again.
The quickest way if there aren't many values (like in your example only 2023, 2024 and 2025) is to add a list of these values as a new column and expanding it.
Otherwise as paladin21 suggested below, merge it from a separate table. That gives you flexibility to change the numebrs in source file instead of the query.
You are a genius thank you very much