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