Dynamically write certain amount of rows and columns when output

hi guys,

I have an output that has 1 column only and can contain up to 5K rows.

How do I create dynamically an out out that splits rows into columns where each column contains only 50 rows and then writes the next 50 items in column on the right?

like such:

A B C

1 51 101

. 52 102

. 53 103
. . .

46 . .
47 . .

48 . .

49 . .

50 100 150

I know I could use select records and then join them with the original resource and alwasy take right anchor but I was wondering if there is a better, more advanced solution.

thanks!

Datasets

Output

Accepted answers

AngelosPachis

Hi @EtamSoko ,

Here's an example of how you can do it using a formula tool to cut off the values at every 50 records. I used a text input tool to look up the headers for the different columns that will be created, so instead of having 1,2,3 you will have A,B,C

sample_workflow.yxmd

All comments

AngelosPachis

Hi @EtamSoko ,

sample_workflow.yxmd

joslynzichawo

Hi, here's an example of how to split the columns. Hope this helps

columns.yxmd

EtamSoko

thanks a lot! The solution you proposed is not exactly the solution I was looking for. Basically I can have one day 295 rows that needs equal 50 rows per columns, and the other day 4776. The tool is doing the thing with the columns that I want with the rows. Regardless, I was not aware of this tool. Thanks for brining it to my attention!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703