Challenge #118: Think Like a CSE - A not-so-wild-wildcard input!
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
RolandSchubert
16 - Nebula
01-28-2019
12:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JoshuaGostick
11 - Bolide
02-06-2019
02:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RichoBsJ
11 - Bolide
02-11-2019
04:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ipeng
8 - Asteroid
03-22-2019
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
TonyA
Alteryx Alumni (Retired)
05-11-2019
12:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If I think of this as a CSE, I would see this as a troubleshooting problem. I probably wouldn't want to give them a macro that purports to pull in any kind of Excel file and reconcile mismatching schemas because then I would wind up having to support the macro (and answer questions like why column 23 is a string instead of a double). So my solution is a workflow that fixes the specific issues with the files. The CREW macro might also be an option as long as the CSE explains what the problem is and points out that the CREW macro does change all the data types to strings.
With that said, I'm still having trouble getting my head around batch macros and reviewing these solutions was very helpful.
Kenda
16 - Nebula
05-13-2019
11:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Have done this many times
I like the way @patrick_digan puts the control parameter constant right in the input file path!
I like the way @patrick_digan puts the control parameter constant right in the input file path!
JamesMA
Alteryx Alumni (Retired)
07-16-2019
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RWvanLeeuwen
11 - Bolide
08-12-2019
06:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Really?
jyotijyoti_dup_475
8 - Asteroid
08-22-2019
10:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cgoodman3
14 - Magnetar
08-30-2019
02:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
The issue is with wildcard inputs when the schema of the Excel file varies compared to the first file read in. I always solve this using a batch macro.
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com