Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

input data with existing formula

shijieleong
7 - Meteor

hi all, 

 

i having problem to input the data with pre-existing formula in the spreadsheet. Attached file for your assistance. 

i just want the column 1. Code & 2. 1st 12 Session (meet 80or more) . 

 

 

the output turn out is 000 instead of "yes" 

shijieleong_0-1646634275215.png

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@shijieleong 
Is it possible to modify the original Excel File?
The column "1st 12 Session" is of Date Format in Excel which will be read in by Alteryx in Datetime Format.
So if we change it to "Text" in Exccel, it can be corrected readin.

Qiu_0-1646637379232.png

 

Qiu
21 - Polaris
21 - Polaris

@shijieleong 
Or we can bring the formula into alteryx.

0307-shijieleong.PNG

shijieleong
7 - Meteor

Thanks for the suggestion! 

Labels
Top Solution Authors