Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question , i need to have it that there is only one date entry for each equipment there is lots of values for equipment so I cant do this. How could I write the if condition that would:
Check if there was multiple entries for the same piece of equipment on the same date in the date field
If true would sum their time and make a single equipment entry in a new table,
If false use this entry in the table
First table that if would operate on:
This is what the new table would look like:
Thanks for your time !
Hi,
In a case like this you can use the Group By statement in your load script.
your load statement would look like this:
LOAD Equipment, Date, SUM(time) as time from source Group By Equipment, Date;
Hi,
In a case like this you can use the Group By statement in your load script.
your load statement would look like this:
LOAD Equipment, Date, SUM(time) as time from source Group By Equipment, Date;
Hi,
Instead of uisng If condition try to calculate it from back end,take the sum of Time field and use GRoup by function and add other dimension in group by except sum(time).
Regards,
Shivani Sapkale
Hi @buster22
I think if you make your time column a measure and use Sum(time) as the expression it should work. Otherwise, if you want to use it as a dimension you can probably use something like AGGR(Sum(time),Equipment,Date).
Hope this helps.
Regards,
Mauritz