Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a situation here.
T1:
PSA | HS | F1 |
P1 | H1 | Aq |
P2 | H2 | Sw |
P3 | H3 | De |
T2:
HS | V | B |
H1 | 2 | 1 |
H1 | 4 | 3 |
H1 | 6 | 5 |
H2 | 8 | 7 |
H2 | 10 | 9 |
H3 | 12 | 11 |
H3 | 14 | 13 |
H3 | 16 | 15 |
The expected output is:
PSA | O=V+B |
P1 | 3 |
P2 | 15 |
P3 | 23 |
Basically the first occurrence of HS.
I need the logic to be in the front end. Can you please help? Thank you.
May be create a field in the script as a flag for first occurrence
T1:
LOAD * INLINE [
PSA, HS, F1
P1, H1, Aq
P2, H2, Sw
P3, H3, De
];
T2:
LOAD *,
AutoNumber(RowNo(), HS) as Flag;
LOAD * INLINE [
HS, V, B
H1, 2, 1
H1, 4, 3
H1, 6, 5
H2, 8, 7
H2, 10, 9
H3, 12, 11
H3, 14, 13
H3, 16, 15
];
Hi Sunny,
Thank you. But I need it in the front end.
I had some limitations, where I could not do changes in the Script in Prod environment.
Do you think of any Set Analysis expression? Thanks.
You can try this:
=Aggr(If(RowNo() = 1, Sum(V + B)), HS, V)
But ideally, I would use something other than V which might be uniquely associated with each row. For the sample it works with V.
Hi Sunny,
One more thing
The Dim is PSA and not HS. Thats the catch here.
Its working still
Thanks Sunny.
This works for me