Text aggregation | Discussions

Expand all | Collapse all

Text aggregation

  • 1.  Text aggregation

    Posted 05-18-2018 14:02
    Hi , Could you please let me know how to aggregate the text field.

    Column1 Column2          Column3
    1              20                    20,30,20
    1             30                    20,30,20 
    1             20                     20,30,20
    2             20                    20,25,30 
    2             25                  20,25,30
    2           30                      20,25,30


    I am new to quickbase , Can you please explain this process in detail

    Thanks


  • 2.  RE: Text aggregation

    Silver
    Contributor
    Posted 05-18-2018 15:18
    What does column 3 represent? How is it derived?


  • 3.  RE: Text aggregation

    Posted 05-18-2018 15:23
    it is the text aggregation based on column 1 --- its kind of list aggregate function


  • 4.  RE: Text aggregation

    Posted 05-21-2018 14:27
    Can some one help on this please


  • 5.  RE: Text aggregation

    Posted 05-21-2018 14:50
    I don't think that any of us are really understanding the question.


  • 6.  RE: Text aggregation

    Posted 05-21-2018 15:10
    let me re-phrase the question

    I have two columns Dept and employee in the table dummy

    Dept       employee
    1              AA
    1               BB
    1               CC
    2               DD
    2              EE


    Now I would like to do a text aggregation based on Dept. I expect the result in the new column as 

    Dept       employee          text Aggregation
    1              AA                     AA,BB,CC
    1               BB                    AA,BB,CC
    1               CC                    AA,BB,CC
    2               DD                      DD,EE
    2              EE                        DD,EE

    In SQL , Something like 
    select dept,listagg(employee,',')  within group (order by dept) from dummy
    group by dept

    will give an answer

    1       AA,BB,CC
    2        DD,EE

    This is my expectation.

    can you please let me know how to do it in quick base. Can you please let me know in detail that will be helpful. I am from SQL background.

    Thanks


  • 7.  RE: Text aggregation

    Silver
    Contributor
    Posted 05-21-2018 15:14

    At first glance this appears to be a parent child relation between Department ( parent ) and Employee (child).

    Department >> has many >> Employee



  • 8.  RE: Text aggregation

    Posted 05-21-2018 16:04
    Can you tell us how many child records would you want to float up the text to the parent record? 

    This can be done via reverse relationships, for say up a half a dozen or so loops.  But if a Parent can have say 20+ children, at some point it will hurt the performance of the app to have so many looping reverse relationships.


  • 9.  RE: Text aggregation

    Posted 05-21-2018 17:52
    There is no limitations to the child record. They can be N. Do you suggest a different approach to solve this ?

    Thanks


  • 10.  RE: Text aggregation

    Posted 05-21-2018 17:57
    There is is not currently a native functionality to float up a text value from a field in "N" child records. 

    There are some non native techniques which I have seen posted on the forum which can be use to do the aggregation and display them on a record, but they will not actually be a field that could be used in a report, for example.  They would only exists when viewing a record.


  • 11.  RE: Text aggregation

    Posted 05-21-2018 18:14
    Hi Thanks a lot for your answer. Is there a way to write a query ? to derive that value


  • 12.  RE: Text aggregation

    Posted 05-21-2018 18:27
    I'm sure there is but i do not know how to do that.  Dan Diebolt would know how.


  • 13.  RE: Text aggregation

    Top
    Contributor
    Posted 05-23-2018 15:00