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

Remove data from the output to get the desired format

Mr_Brown
7 - Meteor

Hi Team,

 

I have data in below format 

Rom\Column123
1102030
2102030
3102030

 and I want the result in format shown below:

Rom\Column123
110  
21020 
3102030

 

 

I am not to sure that if I can use the multifield formula and get the result. Please help

 

Regards,

Piyush

 

2 REPLIES 2
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Mr_Brown,

 

I believe this is what you're trying to achieve?

 

image.png

 

If this solves your issue please mark the answer as correct, if not let me know!

 

Regards,

Jonathan

Mr_Brown
7 - Meteor

Thank You this worked.

Labels
Top Solution Authors