Use of Parameters in Alteryx

Question

Hi Alteryx Community,

I am trying to use a numerical parameter for an operation in Alteryx and I am unsure how to do this.

Essentially, I have data with numerical values and a table of rates. I simply want to upload both and apply the rates to the numerical values using the 'Formula' tool. I have uploaded a spreadsheet to show what I am trying to do.

When I use 'Input Data' for the rates and attempt to join this to the 'Formula' tool, this does not work.

A potential work around (also included in the example) would add the parameters as new fields with the rate repeated over rows, and I can then use them in the 'Formula' function. But I don't know how to do this either.

Do you have any ideas?

Thanks,

Lincoln

UseParameterExample.xlsx

legwu · Answer

Thanks. This certainly works. I can assign a parameter to the Company Bought/Sold data and to the Parameter information, and then join them.

I'm thinking though, is there a way to, and whilst I recognise this is quite inefficient, to append each parameter as a series of fields at the end? This will allow me to use multiple parameters for each row, rather then just one.

For example, if I had another column named Tax (added to the example attached), I can then use a formula for my Post-Rate figure, using multiple parameters based on any requirement on the other fields. This allows for more flexibility.

Whilst assigning input values as parameters would be the easiest way (and I don't think this is possible in Alteryx) is there a way to do this?

Thanks for your help so far.

Regards,

Lincoln

UseParameterExample_wTax.xlsx

Qiu · Answer

@legwu 
Sorry, I misunderstood you afte I checked it again.

1207-legwu.yxmd

Emil_Kos · Answer

Hi @Qiu,

Good idea with using getword function to create a parametr column.

I will remember this one!