I want to create 2 columns A and B. A would loop over each records and a number 1 to 24 and start again 1 to 24. Then I want to add column B which would loop over each record and add A twenty four time then gaain B twenty four timesa then again C twenty fours times. How can I do that with the available modules? Can I do this in a java snippet?
As a good starting point: there is a node called TableRow To Variable Loop Start node (expert mode only), that takes an input table and loop over the values (as variables). Also check the Inject Variables and Extract Variables nodes.