Splitting the column in two by creating a new column

[sriniprad08]

Hi Team,

Hope you are well. I need help.

I have field and i need to split into two and create a new variable with the splitted column.

Please find attached

Acc_key

190007307030002021
190007307130002021
190007307230002021
190007307330002021
190007307430002021
190007307530002021
51058616212019
51058616222019
51058616232019
51058616242019

Output (creating two separate columns and extract the last four digits and place it another column)

Acct   

19000730703000

19000730713000

19000730723000

19000730733000

19000730743000

19000730753000

5105861621

5105861622

5105861623

5105861624

Year

2021

2021

2021

2021

2021

2021

2019

2019

2019

2019

The challenge is that the original column has varying length.

Can you please help?

Thanks

Sri

[mtouiti · Accepted solution]

Hi Sri, 

the team has responded to your same post here https://community.alteryx.com/t5/Alteryx-Designer-Discussions/split-into-columns-without-using-text-... 

Best

Mo