Group by in transaction

[Former Member]

Hi All,

I am getting 600+ records for each three Tags for a month and doing group by by using a xslt in Transaction.Currently transaction is taking so much time to execute.

Is there any other way to do Group by in transaction without using xslt?

Thanks & Regards

Manisha

[Former Member · Accepted solution]

Hi Manisha,

I tried one action Crosstab under XML Functions, it is not exactly group by clause.

you can configure XML columns on which you want to group like tag and month in crosstab action.

After that you can filter your crosstab output data at DrilldownDepth=2 (depends on no. of columns you configured in crosstab).

in result of filter you will get output on tag and month combination.

suppose in your XML you have three columns Tag_Name, Month, Value

(T1, Sep, 10),

(T1, Sep, 20),

(T1, Sep, 15)

Than after applying above logic you will get output like (T1,Sep,45)

Hope it helps!!

Thanks & Regards,

Manoj Bilthare

[Former Member · Accepted solution]

Thanks Manoj.I shall try this and let you know.

Regards

Manisha

[Former Member · Accepted solution]

Thanks Manoj.Its working fine.

Regards

Manisha