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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

INCREMENTAL LOAD OR ONLY UPDATED VALUE LOAD

Meteor

Hi all,

 

I have a file or table like as shown below: example as on 01-Mar-2019

IDNameGenderLast Modified date
1YoganMale28-Feb-2019
2NanthaMale01-Mar-2019

 

& The same file  as on 02-Mar-2019 

IDNameGenderLast Modified date
1YogiFemale02-Mar-2019
2NanthaMale01-Mar-2019
3PrakashMale02-Mar-2019

 

 

But I need a table which should store on 01-Mar-2019 as 

IDNameGenderLast Modified date
1YogaMale28-Feb-2019
2NanthaMale01-Mar-2019

 

I need the same file to contain only 1 updated record and newly 1 inserted record with above one and display as on 02-Mar-2019

IDNameGenderLast Modified date
2NanthaMale01-Mar-2019
1YogiFemale02-Mar-2019
3PrakashMale02-Mar-2019

 

Anybody help in this to achieve this incremental load!!!!!!!

 

Regards,

Yoganantha Prakash G P

Bolide

Use the Union Tool to combine the two files, then the Sort Tool (sort by ID ascending, modified date descending), then the Summarize Tool (group by ID, Name = First, Gender = First, Last Modified Date = First)

 

If your input file names change each day, you may need a batch macro for a fully automated solution.

 

Alteryx Certified Partner
Alteryx Certified Partner

I've just built an example solution to this problem for a demo of this kind of behaviour; check out the attached.

 

Ben

Labels