Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

conditional statem

Hi2023
8 - Asteroid
‎04-05-2023 11:30 AM

 

 

I am trying to create this in a formula and for some reason it is not working? help plz

 

if “Account Number” on input file is equal to “2023” / “2021” put data from “Card #” (input file) in this field

 

 

I tried 

IF [ACCOUNT #] IN ('2023','2021') then
[card] ELSE Null() ENDIF

 

I tried a couple others but really like insight.

 

thanks

 

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
cjaneczko
13 - Pulsar
‎04-05-2023 11:43 AM

I believe you have to convert the account number to a String in order for it to work as you have it typed above. Just tried it with sample Data and it works. 

 

cjaneczko_0-1680720229132.png

 

Reply
binuacs
21 - Polaris
‎04-05-2023 11:46 AM

@Hi2023 check your data type of the field ACCOUNT#, if it is numeric then remove the quotes from the formula 

 

IF [ACCOUNT #] IN (2022,2021) then
[card] ELSE Null() ENDIF

Reply
Labels