Alteryx Designer Desktop Discussions

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

Update Data/Rows based on Actions/Analytics Apps

stevelogue1980
8 - Asteroid

Hi Experts,

User should be able to Enter Rows and store in text input/csv output, for example

 

Current Text input:

stevelogue1980_0-1667594829622.png

 

Expected Text output (can be a table)

Row 99 added (in yellow),I don’t need all fields, just 1 or 2 fields would be great to start with and rest can be nulls

stevelogue1980_1-1667594829647.png

 

Please find the workflow& excel input attached

5 REPLIES 5
Felipe_Ribeir0
16 - Nebula

 

Hi @stevelogue1980 

 

Try the attached workflow

 

app2.gif

stevelogue1980
8 - Asteroid

Update possible for same scenario for 1 or 2 fields in a row?

Let's say, User ID name, Birth date, Gender has to update

 

Here is existing

stevelogue1980_0-1667650934008.png

 

Should update to:

stevelogue1980_1-1667650953949.png

 

TimN
13 - Pulsar

Hi,

I tried something but probably not the most efficient way.  It will update a single record. Test with Browse because the Update overwrites the entire file the way that I did it.

 

Tim

Felipe_Ribeir0
16 - Nebula

Hi @stevelogue1980 

 

Here it is, you can insert or update rows on this version:

inser_tupdate.gif

 

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

 

Felipe_Ribeir0
16 - Nebula

Hi @stevelogue1980 

 

The update worked?

Labels