Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, how can I perform aggr operations in noconcatenate load? While using edit expressions, I am getting error (you have attempted to apply numerical expression, which is not uniquely defined for specific variable). Thank you!
To count you'll need to use a count() and a group by:
CustomerCount:
Load count(Distinct Name) as CustomerCount
From ABC
Group by Name;
-Rob
I have two tables with same structure and I want to perform, f.e. count of name (customers) from second table. Can I use alias like in SQL? I now that I can use FieldCounter, but want to learn how to deal with these issue in noconcatenate load
Data:
LOAD
ID,
Name,
[Business segment],
[Estimated Amount]
FROM
ABD;
Orders:
NOCONCATENATE
LOAD
ID,
Name,
[Business segment],
[Estimated Amount]
FROM
ABC;
To count you'll need to use a count() and a group by:
CustomerCount:
Load count(Distinct Name) as CustomerCount
From ABC
Group by Name;
-Rob
Can I somehow manage this in edit expressions?
Let's say my edit script looks like this and I want to create pie chart with information about favourite color (dimension color and count(name) ??) but only from second table. I want to do this in edit expression, not in edit script mode. Is it possible?
Edit expressions while building a chart