[AnalyticApp] Error when trying to double update a value in app tool

[Joker_Hazard]

Hello all,

I have been sttrugling with trying to make the analytic APP more automated. I have a workflow in which I already have an APP that works. However, this APP only updates one especific field. I would like to make this app tool to update two different fields.

Example:

Banking Account	Company ID
99573173	30723311856658
95427759	40897386274702
98292741	34156613352139

When selecting "99573173", not only the field "Conta_10_linha1" gets updated but also "CNPJ 04_linha1" gets updated with its respective Company ID "30723311856658".

Here's an image of which tool should get updated too... 

The problem is, the user can only CHOOSE/SELECT the banking account. So the Company ID should be updated automatically depending on which banking account was used.

Thank you so much guys!

[jamielaird]

Hi @Joker_Hazard ,

One option is to add a table containing the Banking Account and Company IDs into your workflow, and then join this at the point I've indicated:

[Joker_Hazard]

Jamiel,

I tried to do what you asked, but I'm struggling with making this formula as the "next step"

IF [Conta 10_linha1]=[Banking Account] THEN Replace([CNPJ 04_linha1], [CNPJ 04_linha1], Company ID) ELSE [CNPJ 04_linha1] ENDIF

Alteryx is not allowing me to do this. Do you know why?