I have an Alteryx workflow the size of which is > 100MB, i need to get this size < than 9MB
@olimpio try removing excessing tools such as browse, see if you can minimise number of tools (is there something you can do in fewer tools e.g. rather than 3 filters could you do it in one), that's the best I cuold help with
Hey we did try that, we also tried working on the Metadata as well, but as soon as we run it, it gets larger with every run
@olimpio high chance is too many fields, hence cause the size of xml in select tool, join tool, append tool huge. as well as the metadata. if that is the case, try:1. for all these tool (Select tool, joins tool, append tool and other tool have similar function), try only sort the columns at low as possible, because it will records all field name.
2. try use dynamic select to remove field, where it not load the config as select tool.3. Create the sample file that have least field to represent the solution. so the metadata size is low.
4. Maybe the text input file is huge as well, move it to excel. 5. Convert the yxmd to application so it need not to save the config for new input file. (or do not save the flow after run).
May I ask why does it have to be under 9 megabytes?
Hi @olimpio
In my experience, large xymd files result from one of two causes.
<Field name="OfferedOR" source="Formula: max((IF isnull([10N_Q2]) Then 0 ELSE [10N_Q2] ENDIF),(IF isnull([10N_Q3]) Then 0 ELSE [10N_Q3] ENDIF),(IF isnull([10N_Q4]) Then 0 ELSE [10N_Q4] ENDIF),(IF isnull([10N_Q5]) Then 0 ELSE [10N_Q5] ENDIF)) + 

Max((IF isnull([10S_Q2]) Then 0 ELSE [10S_Q2] ENDIF),(IF isnull([10S_Q3]) Then 0 ELSE [10S_Q3] ENDIF),(IF isnull([10S_Q4]) Then 0 ELSE [10S_Q4] ENDIF),(IF isnull([10S_Q5]) Then 0 ELSE [10S_Q5] ENDIF))" type="Double"/>
Unfortunately there is very little you can do to trim this.
Dan
100MB for a yxmd is definitely a red flag. Usually that means embedded data, massive containers, or cached results blowing it up. I’d check if someone accidentally packaged large input files inside the workflow or saved it with browse data. Cleaning unused tools and turning off caching can shrink it a lot. Feels more like housekeeping than a platform limit issue.
