Last Record

kris_r · Post by **kris_r** » Mon Sep 11, 2006 12:25 am

Hi,
I want to know how to extract the last record of a particular column.
I have 2 columns
A B
1 2
2 3
3 NULL

B should have one value greater than A. The last Record of A should be null. How to extract the last record of A..

sb_akarmarkar · Post by **sb_akarmarkar** » Mon Sep 11, 2006 12:40 am

Hi,

Use aggregator stage choose "Last" aggregation function in derivation....

Thanks,
Anupam

kris_r · Post by **kris_r** » Mon Sep 11, 2006 12:45 am

But, how to assign NULL to that particular last record?

kris_r · Post by **kris_r** » Mon Sep 11, 2006 2:19 am

Any idea Guys?

thurmy34 · Post by **thurmy34** » Mon Sep 11, 2006 2:25 am

Hi

With a transformer you can assign what you want to the last record.

sb_akarmarkar · Post by **sb_akarmarkar** » Mon Sep 11, 2006 2:44 am

Hi,

In transformer use @NULL...

Thanks,
Anupam

kris_r · Post by **kris_r** » Mon Sep 11, 2006 2:49 am

In the same column B, I should increment all the values by One, but the last value should be NULL.

sb_akarmarkar · Post by **sb_akarmarkar** » Mon Sep 11, 2006 3:04 am

Can you provide source data example how it is ?

Thanks,
Anupam

kris_r · Post by **kris_r** » Mon Sep 11, 2006 3:09 am

I have 2 columns A & b.
The column A contains 1,2,3. The Output should be like below:

A B
1 2
2 3
3 NULL

loveojha2 · Post by **loveojha2** » Mon Sep 11, 2006 3:17 am

What about an update after the load, like

Code: Select all

update tgt set b=null where a=(select max(a) from tgt)

kris_r · Post by **kris_r** » Mon Sep 11, 2006 3:29 am

Hey loveojha2

! Thanks, it worked.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 11, 2006 3:51 pm

kris_r wrote:Any idea Guys?

Etiquette Note
This is an all volunteer site. Folks post as and when they can. If you want urgent answers sign up with your support provider for premium service and learn the true cost of "urgent". Don't push. Not everyone is in your time zone, and we do need our sleep.