Alteryx Designer Desktop Discussions

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

Parse Error in my workflow (how to fix it)

Taxguy03
Cometa

Hello Experts, 

 

I had an existing workflow that was working fine until today. The workflow reverses the sign for the liability and equity accounts (6 digits Oracle accounts - all numbers). The accounting department added a new equity account with all letters instead of normal 6 digits numbers. I added the new letter account " FCCS_Retained Earnings Prior" in the string of the formula (see attached screenshot), however, I'm getting a Parse error. 

 

I would appreciate it if anyone can help me to clear the error. 

 

Thanks a lot for your help. 

4 RESPOSTAS 4
Emil_Kos
17 - Castor
17 - Castor

Hi @Taxguy03,

 

If you want to write a string data you need to put it in  brackets ""

 

Emil_Kos_0-1623137175349.png

My magnificent paint skills should give you an idea 🙂 

Taxguy03
Cometa

Oh my gosh, it worked like a charm.😁

 

Couldn't thank you enough, my friend. 

  

 

By the way, your paint skills are a lot better than mine. 

 

Emil_Kos
17 - Castor
17 - Castor

Hi @Taxguy03,

 

Years of practice!

 

Emil_Kos_1-1623138181591.png

 

Taxguy03
Cometa

You're just too modest! Please take care and stay safe. 

Rótulos