Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables Master and Detail.
I have to find the number of occurrences of data Company in IceCream data.
for e.g Occurrence of Amul is 2 and Occurrence of Kwality is 2.
Load your table like
Master:
Load * Inline
[
Company, Location
Kwality, Mumbai
Amul, Bangalore
];
Left Join
Detail:
Load * Inline
[
IceCream, Location
Sundae Kwality, Mumbai
Cone Kwality, Mumbai
Cornetto Amul, Bangalore
Family Pack Amul, Bangalore
];
Noconcatenate
Final:
LOAD
Location&'_'&Company&'_'&IceCream as Key,
IceCream,
Location,
Company
Resident Master;
DROP Table Master;
And on Straight chart take
Dimension:- Company
Expression:- Count(Location) //as Occurance as label
If we remove the location column, lets suppose we have only one column in one table
Here it is
Then there is no relation between the tables and if there is only one column then count its frequency of occurrence.
I think you asking about if there is only one single columns and there are 4 values and each has 2 occurrence if i am right then see the example for that.
LOAD *,RecNo( ) AS Rowid;
LOAD * Inline[
City
Mumbai
Mumbai
Banglore
Banglore
];
In the above table i have 4 values and each has 2 occurrence then we count its rowcount as a frequency
in straight Dimension:-City and expression :- Count(Rowid)
Regards