Discussion board where members can get started with Qlik Sense.
I'm importing 2 tables from my database that looks like this:
and i'm trying to do a table that count the number of CPU for a server and a sum of the RAM for the same server so my table would look like this:
Thanks for helping!
This task don't need any modification in load script.
Place a simple table object on the sheet, and add these dimensions: Key, Server
and these measures: =count(Cpu), =sum(num(replace(Ram,'G',''))
The tables share the Key field, therefore they are linked.
View solution in original post
[Your directory here]
(ooxml, embedded labels, table is Sheet1);
LOAD Key,Server,Count(Cpu) as [Number of CPU's]
Group by Key,Server;
drop table TABLE1;
MID(RAM,1,Len(RAM)-1) as RAM
[your directory here]
(ooxml, embedded labels, table is Sheet2);
LEFT JOIN (TABLECPU)
LOAD Key,Server, sum(RAM) as RAM
group by Key,Server;
drop table TABLE2;