Alteryx Designer Desktop Discussions

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

Parse Error in my workflow (how to fix it)

Taxguy03
9 - Comet

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 REPLIES 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
9 - Comet

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
9 - Comet

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

Labels