Alteryx Designer Desktop Discussions

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

Display field value on new line in Report after number of occurrences

VickyA
5 - Atom

Hello Community,

 

I am trying to figure out how to display a field value in new line in Report Text after certain number of occurrences of a character. So I have a Number field which includes data similar to ****5572,****5185,****5193,****5201,****5219,****5227,****5235,****5243,****5250,****5268,****5276,****5284,****5292,****5318,****5326,****5334,****5342,****5359,****5367,****5375,****5383,****5391. I would want to wrap the data to the next line after 8 occurrences of ' , ' . Currently the data is trimmed off when displayed on a pdf/word.

Attached is a sample workflow and input data.

Thank you

3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

@VickyA 
Lets try something like this

0303-VickyA.PNG0303-VickyA-1.PNG

saveeshkumar
9 - Comet

Hi @Vicky,

 

Please find the workflow.

 

saveeshkumar_0-1646305404470.png

 

VickyA
5 - Atom

Thank you both!

Labels