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

Alteryx designer Discussions

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

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