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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Allow upsert functions using any ID fields

Pushing data to Salesforce from Oracle would bemuch easier if we were able to perform an UPSERT (Update if existing, Insert if not existing) function on any unique ID field in Salesforce. Instead of us having to do a filter to find the records that have or don't have an ID and run an Update or Insert based on the filter.

7 Comments
Meteoroid

I agree this is a useful feature addition

Alteryx Partner

Any updates on this idea?

Alteryx Partner

Any update on this?

Nebula
Nebula

This would not just be useful for salesforce, but this would be a helpful extension to the broader Alteryx platform.

Currently Alteryx allows this kind of capability where a primary key is defined, but this is a fairly costly operation and additionally you cannot do this on a field that does not have an explicit PK defined; or where you have multiple fields that together form the unique key.

 

I'm a supporter.

Alteryx
Alteryx
Status changed to: Under Review

Hi All,

 

We don't have any immediate plans to implement this, but please continue to star if you'd like to see this.

 

Best,

Alex

Please provide this feature. Integration design can be simplified with this feature.

Boa tarde!!

 

Estamos utilizando a ferramenta Alteryx em diversas frentes:

- Extração de Dados ORACLE;

- Extração de Dados SQL SERVER;

- Criação de tabelas;

- Inclusão incremental em tabelas Oracle (Tabelas Z SAP);

- Limpeza e inclusão em tabela Oracle;

- Junção tabelas Oracle x SQL Server.

 

Para ficar uma ferramenta completa, falta a alteração de campos (update).

 

Obrigado!