Alteryx app

[VipulG]

Hi All,

I want to create an Alteryx app which would help the user to understand the position of a particular character in any of the string entered by user.

App should have 2 Interface input options namely,

1. The TEXTBOX to enter the string.

2. The TEXTBOX to enter the character whose position is to be found.

If a character is not found in that particular string, the output should be CHARACTER NOT FOUND.

Example 1: I have entered a string Vishal, and I want to find the position of V in it, then it should give the result as 1. (Since V is at the first position in Vishal)

Example 2: I entered string as Vishal and I want to find the position of T in it, then it should give output as CHARACTER NOT FOUND, since there is no T in Vishal.

Regards

Vipul

[ChrisTX]

Your primary logic will likely be based on the FindString function.

What have you tried so far?  Do you not know where to start to create an app?

The Learning Paths are a great resource: Learn > Academy > Learning Paths

https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117

FindString

FindString(String,Target): Searches for the occurrence of a particular string (Target) within another string (String) and returns the numeric position of its occurrence in the string. Returns the 0-based index of the first occurrence of (Target) in (String). Returns -1 if no occurrence.

Here's a list of all functions: https://help.alteryx.com/20221/designer/functions

Chris

[VipulG]

Hi Chris,

I just need a user interactive app that should ask two questions as soon as we run it. First, "Please enter any string" and second "Enter the character whose position needs to be determined" and then based on these two questions it should give the result.

Regards

Vipul

[ChrisTX · Accepted solution]

Start by creating a workflow and use the FindString function in a Formula tool.  Then when you add tools from the Interface palette, the workflow will become an App with a YXWZ extension.

Also under Academy, check out the Interactive Lessons.   There is a lesson for Creating Analytic Apps.

Chris