Incremental update to a file (csv, Excel)

Question

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?

gautiergodard · Answer

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.

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