Start Free Trial

Alteryx Designer Desktop Discussions

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

number splitting and vlookup

The_Voter
6 - Meteoroid

Hello, first of all i want to thank this incredible community. plenty of solutions listed here are supporting me each day! But as i am new to alteryx some of the solutions go over me...

i have a 16 digit number 1111111111111111, how do i split it to 1111-1111-1111-1111 format?

and the second question:

=IFERROR(VLOOKUP(E2,'Articles December'!$E:$E,1,0),"finished through December") how should it look in alteryx? i suppose it has to be done with find replace tool, but how it should be done, i am not sure...

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@The_Voter 
First one first

0121-The_Voter.PNG

The_Voter
6 - Meteoroid

omg you are the best, i did not expect an answer that quickly😍

Qiu
21 - Polaris
21 - Polaris

@The_Voter 

2nd.

0121-The_Voter-1.PNG

Qiu
21 - Polaris
21 - Polaris

@The_Voter 

Thank you also.

I got two accept from you😁

Labels
Top Solution Authors