Comments
2 comments
-
Hi Alex,
I managed to achieve something similar using Python scripts, but it's not particularly elegant.
For the Set column, I used a "Python script" generator with the following script -number_of_rows_per_set = 3 def main(config): return chr(ord('A') + (int(RowId - 1) - (int(RowId - 1) % number_of_rows_per_set)) / number_of_rows_per_set)
For the Index column, I used a "Python script" generator with the following script -number_of_rows_per_set = 3 def main(config): return int(RowId - 1) % number_of_rows_per_set + 1
You would need to change number_of_rows_per_set in each script and set the total number of generated rows to the number of sets multiplied by the number of rows per set.
This works, but is a bit awkward. There might be an easier way of doing this that I haven't stumbled upon yet, but this might give you some ideas. -
Thanks for the response, Robert. This might help point us in the right direction.
Add comment
Please sign in to leave a comment.
We have 3 sets (A, B, C) and they each have exactly 3 rows, indexed 1-3. The values are random integers.
The real data sets have several hundred items in each set and multiple columns to uniquely identify each set.
Is there any way to generate these sorts of sets in SDG? It seems like the generators work purely on a row-by-row basis but I'm hoping to be proven wrong.