Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Incremental update to a file (csv, Excel)

nora_salagean
5 - Atom

I have a checklist that people select shops from (Name, Value => shop_name, shop_id).
As we open more shops, the list grows... so I need to add a few every so often.
Also, some shops may change name.

 

I'm interested if anyone has a solution for updating my csv incrementally.

I've tried using ODBC (text driver)... it's not working yet for me.

 

Any suggestions?

 

nora_salagean_0-1684418833184.png

 

 

1 REPLY 1
gautiergodard
13 - Pulsar

Hey @nora_salagean 

Yes, one way to do this would be to build a chained application for this. 

The first workflow would gather the list of stores and output a csv/yxdb file in the Name, Value format.

The second workflow would reference this file as an external source (like in the image below) and apply any other transformations you need. 

gautiergodard_0-1684419739600.png

 

Here is a helpful link on chained apps: Chaining Analytic Apps - Alteryx Community

 

Labels