Alteryx Formulation query

[Santhosh_Sangar]

I have an excel with 2 sheets in it and I am trying to do some formulation between columns of these 2 sheets
Can someone provide me some tips on how to proceed.

[TomWelgemoed · Accepted solution]

Hi @Santhosh_Sangar ,

You would need to use 2 inputs int a workflow (1 for each workbook and sheet) and then join the data together using the join tool based on whatever columns are common between the 2 sheets.

Once you've joined the data together, you can use the Formula tool to begin doing calculations.

Hope that helps.

[Santhosh_Sangar · Accepted solution]

This worked
Thanks a lot