Customizing workflow

[Ivaturi_Vighnesh]

Hi Everyone. I am new to Alteryx and need your help in completing the task. I have a dataset with Customer ID, Cost amount, Gross amount, Net amount, Invoice count. I built the XG Boost model for predicting the Cost amount for a single customer ID. But I want to predict it for multiple customer Id. Can someone help me in Customizing the workflow?. Like model should ask me the Customer ID and then it should get trained. 

Thanks in advance

[mceleavey]

Hi @Ivaturi_Vighnesh ,

yes, you simply need to wrap the workflow in a batch macro and use the Customer ID as the batch macro value.

If you can share your workflow I can help you with this.

You should also look into Batch Macros as they are incredibly useful.

You can find out more at the following links:

A good starting point by @EricWe 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

Batch Macro help documentation:

https://help.alteryx.com/20214/designer/batch-macro

A nice walkthough guide by @michael_treadwell :

https://interworks.com/blog/mtreadwell/2015/11/20/control-parameters-and-simple-batch-macros-alteryx...

I hope this helps,

M.

[Ivaturi_Vighnesh]

Hi @mceleavey Please find the workflow below. 

[mceleavey]

HI @Ivaturi_Vighnesh ,

you'll need to export the workflow and package the assets:

[Ivaturi_Vighnesh]

@mceleavey Exported workflow is of 277 mb. Can you help me to downgrade it to lower size?

[mceleavey]

@Ivaturi_Vighnesh ,

this is probably due to the data size. I don't need all your data just a few rows.

[Ivaturi_Vighnesh]

@mceleavey I took random sample of the data and exported. It still has 277 mb size

[Ivaturi_Vighnesh]

Hi @mceleavey Please find the sample workflow below