Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the data in coming like this format , however, there are additional services but there is no data present in db(ex: service 4, 5, 7 &9) thus, data didn't get pulled and table is showing these services..but my requirements is show in table all the services though there is data available or not.. can you help how to write expression to display this.
Due to data to available in db table displaying the values only where data is present in db
service | count | price | total price |
service1 | 4 | 3.5 | 14 |
service2 | 8 | 12 | 96 |
service3 | 5 | 5 | 25 |
service6 | 16 | 14 | 224 |
service8 | 12 | 6 | 72 |
service10 | 34 | 35 | 1190 |
excepted table display
service | count | price | total price |
service1 | 4 | 3.5 | 14 |
service2 | 8 | 12 | 96 |
service3 | 5 | 5 | 25 |
service4 | 0 | 3 | 0 |
service5 | 0 | 5 | 0 |
service6 | 16 | 14 | 224 |
service7 | 0 | 7 | 0 |
service8 | 12 | 6 | 72 |
service9 | 0 | 8 | 0 |
service10 | 34 | 35 | 1190 |
you will need to add data to force 0s
use something like below
comm:
load * Inline [
service, count, price, total price
service1, 4 ,3.5, 14
service2, 8 ,12, 96
service3, 5 ,5, 25
service6, 16, 14, 224
service8, 12, 6, 72
service10, 34, 35, 1190
];
service:
load * inline [
servicetemp
service1
service2
service3
service4
service5
service6
service7
service8
service9
service10
];
load servicetemp as service
,0 as count
,0 as price
,0 as [total price]
resident service
where not Exists(service,servicetemp);
drop table service;
you will need to add data to force 0s
use something like below
comm:
load * Inline [
service, count, price, total price
service1, 4 ,3.5, 14
service2, 8 ,12, 96
service3, 5 ,5, 25
service6, 16, 14, 224
service8, 12, 6, 72
service10, 34, 35, 1190
];
service:
load * inline [
servicetemp
service1
service2
service3
service4
service5
service6
service7
service8
service9
service10
];
load servicetemp as service
,0 as count
,0 as price
,0 as [total price]
resident service
where not Exists(service,servicetemp);
drop table service;