topic Re: How to give old date in App Development

How to give old date

Sra1bandi — Wed, 04 May 2022 10:28:07 GMT

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.

Re: How to give old date

vinieme12 — Wed, 04 May 2022 12:04:49 GMT

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?

Re: How to give old date

Sra1bandi — Wed, 04 May 2022 12:12:43 GMT

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.

Re: How to give old date

vinieme12 — Wed, 04 May 2022 12:48:23 GMT

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;

Re: How to give old date

Sra1bandi — Wed, 04 May 2022 12:53:27 GMT

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

Re: How to give old date

vinieme12 — Wed, 04 May 2022 16:48:03 GMT

Please post some sample data that best represents your dataset

and expected output

Re: How to give old date

Sra1bandi — Tue, 10 May 2022 12:25:22 GMT

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