group by error

[farolito20]

LOAD

                    t_bpid,

                     t_nama,

                     t_ccur,

                    date(now()) as ValidFrom,

                    Timestamp#('31-12-2099 08:00:00','DD-MM-YYYY hh:mm:ss')          as ValidTill,

                     //date(now())                    as          ValidTill,

                    Checksum,

                    1 as MostRecent

          Resident DimOld

          Where exists (Checksum2, Checksum) and t_bpid = $(vCustomerNumber) and MostRecent=0

  Group By MostRecent

The error: aggregation expressions required by group by clause

[shree909]

Hi,

i am not sure  but if u are uisng group by clause u need to have aggregations .

but in ur case i dont find any aggregations (like , sum , count,max.....)so group by doesnt work

if i am wrong can u post a sample file

thanks

[farolito20]

Ok, Thanks

I need to load just one row of this load, do you know how?

And another question, Do you know how to know if a table is empty?

[farolito20]

My table is resident :s

[shree909]

if u want to load one row take the unique id of the field  use match function..

where match( fieldname, value)

[farolito20]

what is match and how to use it?

[MayilVahanan]

hi

have a doubt? can u able to clarify? which row u want? only one row or value?

first can use in this case , if u want to load first row only in a table.

if u want to load a rows based on a value,

load a,b,c resident tablename where b = '12';

in the above case , it load oly row which contain b has 12

in ur example, u assigning 1 as mostrecent? but in where condition  usong mostrecent = 0?

i think due to this oly u can't able to get values.