How to aggregate of data with different dimensions across modules.

taku.s

Hi everyone.

I have two modules. Each module has different dimensions.

And I would like to aggregate these modules to one modules.

Please see below:

I assume that it will be solved by importing data between modules.

But I don't know the specific solution.

How can I solve the problem?

Best regards,

Taku

Accepted answers

Kanishq17

hi @taku.s

create a new list which contains all the list members of module 1 and module 2, either manually or by importing action (list-list import) and then create a module with this list and the line items of modules, then import twice from each module and keep those actions in a process

All comments

Yash1

Hi @taku.s ,

Why do you want to aggregate 2 different dimensions the way you have shown, Is it only for display purpose?

If it is only for Display, you can just publish the 2 modules on the dashboard, otherwise you cannot have 2 dimensions one after another in a module.

Let me know if this helps, other wise can you please explain your query in more detail.

Thanks,

Yash

Panji

Hi @taku.s

I think you need to

1. create new list(Module C)

2. Create Saved View in Module A and Module B

3. Import data module A and Module B using saved view to new list properties and in module C use formula from new list properties or

4. Import data module A and Module B using saved view to Module C

Regards,

Panji

taku.s

@Yash1

Thank you for your reply.

Because I would like to output the data as one flat file.

I aggregate 2 different dimensions.

Best reagards,

Taku

Kanishq17

hi @taku.s

taku.s

Hi,@Kanishq17

Thank you for your reply.

I'll try it later!

regards.

shubham

Hi,

1. Create a New List .

2. Now Create 2 Line Items in the previous two modules to create the Codes for Importing the List items in the New List. Line Item 1 formula(1st module): CUMULATE(1,FALSE, 'List 1 Name'). Set the Summary of this Line item as 'MAX'.

3. Line Item 2 formula (2nd Module): CUMULATE(1,FALSE, 'List 2 Name')+ 'Line Item 1'[SELECT: Top Level of List 1]

4. Now You can import from both the Modules using these two Line Items as Codes into the new list.

5. Then create a new Module with this list and the corresponding data in the module.

Hope this helps!

Regards,

Shubham

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…