Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a question because I can't find a solution; I have a fairly large source table that has a lot of similar records. When I try to do distinct or group, it doesn't work. Why?
I will add that I use "resident" when loading.
Example:
Columns: Day, Month, Qty, Value
Load
month,
sum(Value) as SumOfValue
Resident TBL
group by Month;
This doesn't work - the Month value should be unique in the result. But it is not. What could be the reason?
I think I know why, "Month" was created with the format() function. Converting to text solved the problem.
It's case sensitive. "Month" is not the same as "month".
Hi @hic , thanks!
Of course, my mistake in the description.
Load
Month,
sum(Value) as SumOfValue
Resident TBL
group by Month;
I think I know why, "Month" was created with the format() function. Converting to text solved the problem.