We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How update excel file with updates.

tomekgagola
7 - Meteor

Hi All, 

 

I am still relatively new to alteryx but I wonder if anyone can help me out with the task I want to develop in designer.

 

I have got 'master file' that is excel file and I get updates to that file. The 'master' has 10,000 rows and 80 columns. There is a ID column that I use as Primary Key. The update file might have some rows changed but not all, it might contain unknown number of rows. 

 

My idea was to use ID column in update file and based on that update that ID row in Master only if any update was done?

 

I hope it does make sense 🙂

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @tomekgagola 

 

The concept you are speaking about is only available for SQL database output. Where you can update only specific rows based on primary key.

 

For excel if you want to update specific rows only way you can do it is

1. Read all the data.

2. Update the required data in data manipulation stage.

3. Overwrite back all the data into the file.

 

Hope this helps : )

tomekgagola
7 - Meteor

Would you be able to expand on Point 2?

atcodedog05
22 - Nova
22 - Nova

Hi @tomekgagola 

 

Here is an example.

 

Workflow:

atcodedog05_0-1630917015460.png

 

1. Read in both main data and update data.

2. Use union tool to merge them together. Make sure to set the output order in union tool as #1 (old data) and #2 (new data).

3. Using sample tool groupby on Primary key (here its CustomerID) keep last row. This way old data is replaced with new data wherever applicable.

 

Hope this helps : )

Labels
Top Solution Authors