Free Trial

Alteryx Designer Desktop Discussions

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

Write to a comment box dynamically

Amsaini15
6 - Meteoroid

Hi 

  Can someone please help me with alteryx flow to write to a comment box (there are few so need to write to particular comment box to avoid creating new comment box on every run) the outcome values of summarize function in a particular way (Expected Outcome below). Please let me know if you have any question. Thank you in advance

 

Current Setup

 

CurrentAlteryx.jpg

 

Outcome of 1st Summarize (TableStarting)

 

TableStarting.jpg

 

Outcome of 2nd Summarize (TabeDr) It could have more rows D,E,F with count.

 

TableDr.jpg

Expected Outcome (Comment Box)

 

CommentBox.jpg

 

 

 

 

14 REPLIES 14
caltang
17 - Castor
17 - Castor

If you want to add a loop - you can! Can you give me some sample data? I'll do a copy for you and make it as dynamic as possible to cater to your needs.

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Amsaini15
6 - Meteoroid

Thanks @caltang . TableDr could have any number of rows from A to G. So it could be just A & B sometimes and then A,B,C & D sometimes or A,B,C,D,E,F. I have created sample table below.

 

A - 36

B - 74

C - 14

D - 20

F - 12

 

 

caltang
17 - Castor
17 - Castor

Done! Made it dynamic :)

 

image.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Amsaini15
6 - Meteoroid

Perfect!! It works great. Thank you very much @caltang . It was confusing but you made it easy.

caltang
17 - Castor
17 - Castor

Happy to hear that! Enjoy Alteryx!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors