Alteryx Designer Desktop Discussions

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

How to add String in multi-rows dynamically

k3pineapple
8 - Asteroid

Hi All,

 

Trying to add one list of code into a function dynamically. But it seems not doable in "Formula" function.

Not sure what tool/function i should use for this.

 

Additionally, not sure whether it is possible to add fixed string in there,(i.e.: "/*/")

 

Many thx

 

Input 

Member
ABC
DEF
GHI

 

 

Alteryx Error.PNG

 

 

 

Desired Output

 

Formula
=Test_ABC("ABC","","/*/","/*Rank*/")
=Test_ABC("DEF","",,"/*/","/*Rank*/")
=Test_ABC("GHI","","/*/","/*Rank*/")
2 REPLIES 2
caltang
17 - Castor
17 - Castor

Use this:

'=Test_ABC(' + ToString([Member]) + ',"","/*Rank*/")'
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
k3pineapple
8 - Asteroid

appreciated @caltang 

Labels