We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
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