We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Excel Input with Columns not matching

tigertoy9
6 - Meteoroid
‎02-19-2020 02:26 PM

I am having an issue, as I am pulling in several excel spreadsheets, and need to run this workflow monthly.  Issue, a field called "MBP-PED-BEG-DATE" has some monthly spreadsheets with the title with a space in front of it, and others with two spaces.  Only field that does that.  How do I check if the field has a space or two, and strip them off before proceeding so it will count everything?

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

10 REPLIES 10
tigertoy9
6 - Meteoroid
‎02-20-2020 07:12 AM

It did not work, sorry.

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All