community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Only output file If there is new data from SQL data set compare to the existing Excel file

Highlighted
Atom

Hi All,

 

I am new to Alteryx and trying out few things. Need to know the following workflow scenario solution:

 

I have data source coming from SQL server (Always fresh data) and an identical data set in Excel file (Last produced file). I want to compare them and only if there is a mismatch in both data sets then I want to produce a new excel file else leave it.

 

Is the above scenario possible in Alteryx?

 

Thanks

 

Regards

Syed

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Syed110 

 

It's totally possible and there are lots of ways to accomplish that.

 

Do you want to insert new records to your Excel File when you see a mismatch or you want to overwrite your excel file with SQL data?

 

Cheers,

Atom

Hi @Thableaus,

 

Thanks for your quick response.

 

I want to just replace the existing Excel file If changes found while comparing SQL data and the old excel file.

 

Thanks

 

Regards

Syed

Alteryx Certified Partner
Alteryx Certified Partner

@Syed110 

 

Just to be clear: the data structure must be the exactly the same too?

I mean - Metadata  (column names, column types, column order), row order..

 

Cheers,

Atom

The meta data is same as the last file is also produced using the same SQL

 

Metadata  (column names, column types, column order) are same

 

The row data can be different but it shouldn't really matter.

 

Thanks

Labels