Most solutions I've found on how to simulate a cross join in Qlikview involved using a full outer on tables that don't share a commonly named field and then trim the rows in excess.
What I am curious to find out is whether the same could be achieved using two for loops nested one in the other. I am not interested in whether it is a more/less efficient solution here, just in the technical feasibility.
In very-pseudo-code it would be something like:
for each row in table1
(string) concatenate field 1 &
for each row in table2
This should give us a table with the desired cardinality and just one field. Then we could use left() and right() to pull out the original fields.
Unfortunately I struggle putting this into proper Qlikview syntax, any idea?