Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have this .csv file:
ID product quantity
1 123
2 456
3 789
4 Null
5 852
My problem is that I want to find a way to count, in a table, ID product only if the quantity is not Null
May be this
Count(DISTINCT {<quantity = {'*'}>} [ID product])