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 | |||
Solved! Go to Solution.
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
Try this.