Create a new column using Formula

Hi Alteryx Support - Need assistance from your side on below logic - Thanks in advance.

I need to create a new column based on Identifier field like below shown.
If identifier contains 7 Character then ISIN,
IF Identifier contains 9 then Cusip.


Input

ID	Identifier
1	XFPUTH3
2	RFPTYH3
3	RFPTYH3
4	78TYHJGHF
5	U8TYDSGHF

Output

ID	ISIN	CUSIP
1	XFPUTH3
2	RFPTYH3
3	RFPTYH3
4		78TYHJGHF
5		U8TYDSGHF

Datasets

Accepted answers

cjaneczko

Try this.

All comments

ShankerV

Hi @Jaganmohan

Please use the below,

1. Formula tool

Add Column name -> ISIN

IF length([Identifier])=7

THEN [Identifier]

ELSE null()

ENDIF

Add Column name -> CUSIP

IF length([Identifier])=9

THEN [Identifier]

ELSE null()

ENDIF

Optional Step 2: If you need to remove the column Identifier post step1, then use Select tool to deselect the column.

Many thanks

Shanker V

cjaneczko

Try this.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703