Create a new column using Formula

[Jaganmohan]

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

[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 · Accepted solution]

Try this.