Hi Anaplanners,
I am Simon from DXC. I am working for a requirement which needs to generate a cross-join list based on 2 lists. But I doubt if Anaplan can do this like SQL queries. I would like to take any workaround as well.
We have 2 lists: one is for Managment Nodes and another for Industry.
In Management Nodes there are 3 records: A, B and C
In Industry 4 records: 1, 2, 3 and 4
We need to cross-join these records and save them to another numbered list, this list should have 3*4=12 records like below:
A 1
A 2
A 3
A 4
B 1
B 2
B 3
B 4
C 1
C 2
C 3
C 4
If anyone can give any solutions or workarounds that will be appreciated. Thanks a lot in advance.