Tried some of the older threads here, but to no avail. Been going crazy with iteration/chunk loop/table to row variable/etc :(
What I am trying to do:
Table 1: I have a fixed table with 352 rows (and z columns).
Table 2: Second table (using currently table creator, could be done by file read) having say x columns in 10 rows.
I want to created a new table where
Table 1 columns plus columns table 2 contents of only row 1 in all 352 rows.
then repeat table 1 + table 2 row 2, table 1 + table 2 row 3 .... etc; see example below
so that I would have 3520 rows in total.
This table would later get reiterated against yet another table as the next step (but not the current issue here)
TABLE 1:
a
b
c
d
....
TABLE 2:
XX1
XX2
XX3
....
end result:
a XX1
b XX1
c XX1
d XX1
....
a XX2
b XX2
c XX2
d XX2
....
I enclose a csv files if that helps?