Populating Numbered List from a Module with 4 or more dimensions:

[BhumikaTewari]

Use Case:I am trying to create a Numbered List from a module with 4 dimensions typically SKU, Tier, Product and Level & few Line items. For modules dimensioned by 3 lists it is straightforward to create a View as the source of the Import with the 3 lists as Column items and the Line Items as Row items. Unfortunately this does not extend to 4 lists as you can't have 4 lists as Column items in the view pivot.

年代ource Module:

Target List:

年代olution-

年代tep1:

Create a Helper list with 10k items(can be extended depending on your combination size).

步骤2:

Create 2 lineitems in your source Module:

Name	Format	Formula
Ranking	Number	RANK(1, ASCENDING, SEQUENTIAL)
Helper Format	Helper(list)	FINDITEM(Helper, TEXT(Ranking))

年代tep3:

Create a new Staging Module with Helper list as the dimension:

Create a lineitem to fetch the Concat from the Source Module & another for filtering the saved view:

Name	Format	Formula
Concat	Text	年代ource Module.Concat[FIRSTNONBLANK: Source Module.Helper Format]
NOTBLANK Concat	Boolean	ISNOTBLANK(Concat)

年代tep4:

Create a saved view in the above Staging module.

年代tep5:

Create an action to transfer this data from the above Saved view into the numbered list.

[JaredDolich]

@BhumikaTewari

Nice solution!

[BhumikaTewari]

Thank you@JaredDolich

[PhilippErkinger]

Very smart idea, love it! I would recommend to add a counter in a separate module that checks if the 10k list items is enough. Just to avoid hidden failures.

[BhumikaTewari]

Thank you@PhilippErkinger.
Couldn't agree more on the Counter module & it can even be used to populate a subset of the bigger(Helper) list.

[PhilippErkinger]

...and not to forget; RANK has a limit of 50 Mio Cells. But at such a high cell count, FINDITEM will also become concerning for the performance.