Macro for Tiles

Question

Hey everyone,

I have the challenge to first split the initial input into unique tiles and merge them after their respective calculations back together. I am aware that I could basically just filter based on the Tile number and then do this n-times but I would prefer having a macro since the steps for each tile group are the same (first row is skipped, data cleansing to remove null rows and formula for calc) and therefore standardised.

Does anybody have an idea how I could kick start this split and merge dynamically (n-amount of tile groups)?

Thanks in advance!

caltang · Answer

Hmm, the way you're looking at it is to filter for each Tile_Num and then run a process through it, then spit it out. Repeat n times until all Tile_Num are exhausted right?

Now, that's fine but I still don't get why you need to batch it sequentially. What sort of formula are you applying to it that requires for it to one by one?

If you're already skipping the 1st row, you can continue with the Sample tool. So I still fail to comprehend the need... it's a slow Wednesday for me so I need some more context if you can... maybe a larger sample data set and an expected output will help tremendously.

Cela · Answer

Thank you for the suggestion @caltang!

I am using the sample tool for the skipping after the tiles are split up because I need to skip every first row of each tile group. In the example above I end up with 4 separate results as there are 4 tile numbers. If the sequence was longer for each tile number, I would have to skip the first row respectively.

What I am looking for is a way to let tile number 1 run through a batch macro first, then number 2 and so on until n.

My idea for now is to update the value of the filter tool based on Tile_Num so that the reference remains variable.

Would you happen to have a suggestion for this scenario?

caltang · Answer

Hi @Cela

If you're skipping every 1st row and cleansing it then formula it, why don't you try the Sample tool instead: