Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys, I got stuck in this apparently simple thing, but I still can't solve it.
I put a simple example to make you understand :
If I have a table like this :
How can I get this result (cleaning all the null values, and storing the results in one row):
Field1, Field2, Field3, Field4
1 , 2 , 3 , 4
Hope someone can help me telling me how can I do that.
Many thanks in advance!! Cheers!
Load
field_to_group,
max(Field1) as Field1,
max(Field2) as Field2,
max(Field3) as Field3,
max(Field4) as Field4
from/resident table
group by
field_to_group
;
But, if you have other field to group, use the yellow code too
Rgds
.
Load
field_to_group,
max(Field1) as Field1,
max(Field2) as Field2,
max(Field3) as Field3,
max(Field4) as Field4
from/resident table
group by
field_to_group
;
But, if you have other field to group, use the yellow code too
Rgds
Thanks Hector, this is the kind of easy things you got stuck once in a while.
In addition, if you have the same with characters, you can use maxstring() as well.
See you around