Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

Joker_Hazard
11 - Bolide

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 AccountCompany ID
9957317330723311856658
9542775940897386274702
9829274134156613352139




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... 

Joker_Hazard_0-1613995151482.png

 

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!

2 REPLIES 2
jamielaird
14 - Magnetar

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:

 

jamielaird_0-1613997299888.png

 

Joker_Hazard
11 - Bolide

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?

Labels