How to cross-join 2 lists
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:
If anyone can give any solutions or workarounds that will be appreciated. Thanks a lot in advance.