How to get data size on Group by? Also for a table input and output?

Question

Alteryx Community,

Let me know if you could help. How to get the data size on Group by column? Also for a table input and output?

Regards,

Himanshu

grazitti_sapna · Answer

Hi @himsnshug , I hope this is what you are trying to achieve? The size is in bytes though but still close to what you are expecting.

@Qiu the solution you provided is useful but I tested few cases and would like to inform you that the field info tool just provide you the size of the maximum characters in the field. To support this finding, try using a select tool and check the field size and then check the size of field info tool which is actually the size of field not the data. Therefore, a blob tool will be helpful in this case.

If this is what you are looking for kindly, mark this post as solution.

Thanks.

Data Size-GS.yxmd

Qiu · Answer

@himsnshug

I have to combine the data columns and expecting it will affect the data size.

1204-himsnshug.yxmd

Qiu · Answer

@himsnshug

Agree with @AngelosPachis , more details required for anwsering the query here.

By any chance, you mean the Field Infor Tool?