We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Bold and point form

Sifiso
8 - Asteroid

Hi all

How do I make part of the string bold and break down the concatenated output into three lines?

I have concatenated three fields: [incident], [Cause] & [Solution].

example: “Incident:” +” “+ [Incident] +”  “+ “Cause:” +” “+[Cause]…

 

This is the output I want:

 

Incident: The bolt was 2mm out of spec.

Cause: obsolete drawing was issued.

Solution:  remove obsolete drawings from the system.

2 REPLIES 2
FrederikE
13 - Pulsar

Hey @Sifiso,

 

In order to format your text you would need Reporting tools and write the output using a Render tool. 

See the attached example WF. 

 

FrederikE_0-1684494214093.png

 

e.g. as an excel:

 

FrederikE_1-1684494302055.png

 

Sifiso
8 - Asteroid

Hi FrederikE

 

Thanks for trying, I think my request was misleading, let me rephrase it.

 

I want the logic that will put the text in point form in the same cell.

Example: If this delimiter “|” is picked up then start below

Current situation

ID

Summary

0001

The bolt was 2mm out of spec. | obsolete drawing was issued. | remove obsolete drawings from the system.

 

Required Output

ID

Summary

0001

- The bolt was 2mm out of spec.

- obsolete drawing was issued.

- remove obsolete drawings from the system.

Labels
Top Solution Authors