Alteryx Designer Desktop Discussions

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

How to fix text that wraps to a new line from an excel report?

joesparty
8 - Asteroid

Hello,

 

The attached is a sample of a report in excel format that writes long text to a new line.  I've included an Output worksheet of the desired results.  Is this possible in Alteryx?  I tried Text To Columns and Make Columns with no luck.

 

Thank you!

5 REPLIES 5
gabrielvilella
14 - Magnetar

You must have a way to determine which lines should be combined into the same record. I don't see any pattern on the data. 

ChrisTX
16 - Nebula
16 - Nebula

If you were manually combining the rows, if you can define one or more rules that you would follow, you could write a workflow.  But if some of the text is subjective, without any definite rule to follow, there's nothing you can do.

 

For example, I don't think there's any logic you could define to know that the two rows for group 10 should be combined.  Other than hard-coding logic for something like "the word Vendor on a line by itself should be combined with the row above".

 

Desired Group NumberOriginal Text
12021-AF-INV- INVESTIGATIONS | 
1Investigation Activities- 2021
22021-AF-SOX | SOx Activities for  - 
22021
3Nonworking
4General Admin Time
5Onboarding - On the Job Training
6Training - Non-CPE
72020-GLOBAL-SER-GLOBAL RESPONSE 
7COMMUNITY FUND | Global Response 
7Community Support Fund
82021-GLOBAL-LEG
8| Review
92021-GLOBAL-OBJ- TEAM MEETINGS | 2021 
9Team Meetings
102021-GLOBAL-OPS-SECURITY | 2021 Security 
10Vendor
112021-GLOBAL-RMS-RMS SUPPORT  | RMS
11Support - 2021
12Nonworking

 

Chris

joesparty
8 - Asteroid

Hi @ChrisTX,

 

Good point, I've updated the sample to include additional columns from the report to help with logic.  The text wraps when:

  • Code begins with a year
  • Code contains '|'
  • Project > 0

If Project IsNull and Nonworking or Admin >0 then the text doesn't wrap.

 

 

gabrielvilella
14 - Magnetar

Hi @joesparty, see if this is what you are looking for:

gabrielvilella_0-1644347071883.png

 

joesparty
8 - Asteroid

Wow very cool approach, wasn't sure how to account for the 3 lines!  I also learned that you can concatenate in the Summarize tool, very helpful!

Labels
Top Solution Authors