Want to Update Different Figure in Output file.

[Srawat]

Hi,

I have created a below workflow and want to update the figures. Can I update the yellow different figure in  green table for ID-S1235 in particular 2 column through Alteryx workflow?

Thanks,

[Amol_Telore · Accepted solution]

Hey @Srawat 

It is my understanding that you want to update data in Table 1 from Table 2 values for respective columns. If this is requirement then below solution will work for you.

Regards,

Amol Telore

[Amol_Telore]

@Srawat I have updated solution. Please refer new file.

[Srawat]

Hi Amol,

Thank you so much for the solution. It works perfectly.

I have one more challenge after updating the yellow figure in green table. In green table all the figures are formulated if one change then other dependent figure will change. but the other dependent figure is appearing as it is. Please advise, dependent figure needs to change as per the updated figure.

Yellow cell not updating.

Thanks,

[Amol_Telore]

@Srawat Do you have formulas in all the fields A to E or it is only applicable for column E. We can use formula tool to re-calculate the value of E field with new values.