Need it in the front end

[Saravanan_Desingh]

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.

[sunny_talwar]

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

];

[Saravanan_Desingh]

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.

[sunny_talwar]

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.

[Saravanan_Desingh]

Hi Sunny,

One more thing

The Dim is PSA and not HS. Thats the catch here.

[sunny_talwar · Accepted solution]

Its working still

[Saravanan_Desingh]

Thanks Sunny.

This works for me