Append latest data in target using date field in source

Hi,

I am trying to append latest data basis latest date in source table.

For ex: Max(date) in source: 10/12/2020

Max(date) in target:11/12/2020.

first i want to check max date in both tables and if max date in source is greater than max date in target then append latest date data in target table.

Accepted answers

All comments

grazitti_sapna

Hi @Agarwal_Yash91 , do you have sample data in order to achieve this?

Other way around can be filtering the data on the basis of date and then append it to the existing table.

Thanks.

Agarwal_Yash91

Sample Data

Date	Amount
9/12/2020	6
9/12/2020	7
9/12/2020	10
9/12/2020	11
9/12/2020	15
10/12/2020	20
10/12/2020	25
10/12/2020	30
10/12/2020	40
10/12/2020	50

Target

Target
Date	Amount
9/12/2020	6
9/12/2020	7
9/12/2020	10
9/12/2020	11
9/12/2020	15

I want to insert data for 10/12/2020 in my target table.

Qiu

@Agarwal_Yash91
Is something like this?

1210-AgarwalYash.yxmd

Agarwal_Yash91

Hi @Qiu ,

i am looking for something like this but using INdb operations as my source and target are database tables and we dont have join by position and append fields tool available for in-DB operations

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

hhaigh1 280