topic Re: Multiply values in column in App Development

Multiply values in column

iglou — Tue, 24 May 2022 10:14:37 GMT

Not sure if this was asked before.

I would like to multiply the "Availability" column for the same system based on the table below:

LOAD * INLINE [

System, Sub-system, Availability

A, A1, 1

A, A2, 0

A, A3, 1

B, B1, 1

B, B2, 1

C, C1, 0

C, C2, 0

]

The final table should look like this:

System, Availability

A, 0

B, 1

C, 0

Any idea what could be a good way to do this?

Re: Multiply values in column

justISO — Tue, 24 May 2022 10:23:20 GMT

Hi, if 'Availability' field only have 0/1 values, maybe something like this:

DATA_temp: LOAD * INLINE [ System, Sub-system, Availability A, A1, 1 A, A2, 0 A, A3, 1 B, B1, 1 B, B2, 1 C, C1, 0 C, C2, 0 ]; MAIN: LOAD System, if(sum(Availability)<>count(System), 0, 1) as Availability RESIDENT DATA_temp GROUP BY System; DROP TABLE DATA_temp;

Re: Multiply values in column

iglou — Tue, 24 May 2022 10:26:15 GMT

Sorry I wasn't clear in my question.

It is true that availability contains 1 or 0 only.

So basically, if there is any 0 in the sub-system, my entire system is unavailable (ie, should return 0)

The output I wanted to show is in the chart view, not in the script view.

Re: Multiply values in column

marcus_sommer — Tue, 24 May 2022 10:28:39 GMT

Maybe you could apply the following logic:

t1: LOAD * INLINE [
System, Sub-system, Availability
A, A1, 1
A, A2, 0
A, A3, 1
B, B1, 1
B, B2, 1
C, C1, 0
C, C2, 0];

m: mapping load distinct System, [Sub-System]
resident t1 where [Sub-System] = 0;

t2: load distinct System, applymap('m', System, 1) as Availability
resident t1;

- Marcus

Re: Multiply values in column

justISO — Tue, 24 May 2022 10:32:42 GMT

So the way to get this wanted result at report level with my suggestion is very similar, just use

if(sum(Availability)<>count(System), 0, 1)

Re: Multiply values in column

iglou — Tue, 24 May 2022 10:45:30 GMT

Got it! Thanks! 😄

Re: Multiply values in column

MarcoWedel — Tue, 24 May 2022 12:18:00 GMT

Min(Availability)