nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Tile tool- Equal Records Method- How to dynamically update Number of Tiles?

gcosta

Hi guys, good morning.

Looking for some advices here. I am using the Equal records tile method to group my dataset. Perfect! However, the number of tiles in this process changes every once in a while.

So, instead of having to manually change this value in the tool, is there a way that I can dynamically update this value using i.e. the count of records tool which contain the number of tiles that I would like to group my dataset every time I am running the process.

Really simple example attached.

Hope this makes sense.

Thank you so much for your help.

Equal Records Tile.yxzp

Dynamic Processing

Accepted answers

davidskaife

Hi @gcosta

Turn it into a macro and feed the number of tiles you need in to it as a control parameter:

Equal Records Tile.yxzp

DataNath

Great suggestion from @davidskaife! Only thing I'd add is, especially if this is going to be applied to a large data set, you may just want to use a Summarize tool with a count (or count Distinct depending on requirement) rather than Count Records as the latter is also a macro itself and will lead to decreased performance at scale.