We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #118: Think Like a CSE - A not-so-wild-wildcard input!

rachel_lynch
Alteryx
Alteryx
Spoiler
A not so wild wildcard input.png

Rachel Lynch
ed_hayter
12 - Quasar
Spoiler
Batch Macro Use Case

Use the Control Parameter to Update the file path - union data auto configure by name.

Challenge 118 WF Image.png
DaisukeTsuchiya
13 - Pulsar
Spoiler
スクリーンショット 2023-08-31 222404.jpg

gawa
15 - Aurora

DOne

Sebastian_Chaieb2
8 - Asteroid

One of the best usage of Batch macro 

Spoiler
118_workflow.PNG
Batch macro
118_Macro.PNG

  

Hammad_Rashid
11 - Bolide

DataAnalyst23_0-1701323339041.png

 

RWvanLeeuwen
11 - Bolide

retaking this to prep for expert exam

proposed solution

Spoiler
118 it works after batching and I set up the customer path bath.png

bonus question

Spoiler
another Control Parameter tool combined with an Input Data tool as to influence the file type for data input, meaning the Dynamic Input tool would not be used then
olga_strubbe
10 - Fireball

 A neat challenge, thank you, @EddieW  - true to real-life use case.

My workflow: 

Capture im.PNG

 

My macro:  please update macro input with your file path  - I entered a placeholder in the attachment - sorry, not able to share mine due to security.  Thanks!

Capture a.PNG