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!

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