This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I am looking understand, if there is a way , once excel file is imported to alteryx i can check if lets say "#" is available within any of the cells thats imported. based on that check i am looking to create a column with appropriate comment such as "special character found"/"special character not found"
Yes, this is definitely possible. Just so I understand correctly, would the new field be based on any of the fields for a record containing that character, or would all fields need to contain the character?
If this is the case, please check the sample workflow attached to see if this would work in your instance!
Lets say i have an excel file called abc.xlsx and Sheet 1 from it is what i have imported on to Alteryx. Lets say it data across 10 columns and 10 rows. I want to know whether "#" is there within this data.
PS: I do not want the range where the search is made to be static.