In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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