How to give old date

[Sra1bandi]

Hi team,

i have two tables 

Table 1:

Number     Date 

001               02-11-2021

Table 2:

Number     Date 

051              04-11-2022

i want old number date  is replaced with new number how to achieve it.

Thanks,

Sravan.

[vinieme12]

Can you provide more details on the use case here? Or what are you actually trying to do?

Will your tables always have one row?

How do you know which table is latest?

[Sra1bandi]

Hi Vinieme,

Thanks for giving reply.

Table 1 is old and table 2 is new 

there are 150 numbers like that with date i have to replace the same date with for new 150 numbers .

Thanks,

Sravan.

[vinieme12]

As below

Old:

Load ID,Date from oldtable;

Left Join (Old)

Load max(date) as newdate from newtable;

Drop field Date from Old;

Rename field newdate to Date;

[Sra1bandi]

Hi Vineeth,

Thanks for reply.

But here there is no common thing to take dates while joining in new data there are approx 1k numbers are present.

in that 1000 numbers this these 150 numbers are present, how it will merge with that 150 numbers 

[vinieme12]

Please post some sample data that best represents your dataset 

and expected output

[Sra1bandi]

Hi 
Table 1 and Table2 uploaded files 

Table 2 has 150 same ppcr numbers which are also present in Table1

but i need for same PPCR# i need Table2  created date instead of table 1 created date