Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
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
inspire ask me anything
inspire session catalog
Labels
Top Solution Authors
View All