Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Extracting a cell from a field where it's a date

Brawlstrogg
7 - Meteor

Hi folks,

 

I've got a field that shows like the below;

 

01-12-17
Example
Example 2
Example 3
02-12-17
Example
Example 2
Example 3

 

It's a blend of work items and dates and I can't seem to figure out a way to separate them so it'd look like the following;

 

01-12-17Example
01-12-17Example 2
01-12-17Example 3
02-12-17Example
02-12-17Example 2
02-12-17Example 3

 

Any ideas?

2 REPLIES 2
vishwa_0308
11 - Bolide

Hi @Brawlstrogg,

 

Please try this workflow attached..hope it will figure out your solution.

 

Pic2.jpg

 

Best,

Vishwa

Brawlstrogg
7 - Meteor

I found a work around within the workload I had which is good.

 

But just tested this and it works as well. Thanks buddy.

Labels
Top Solution Authors