Skip to main content
Question

How to join multiple columns?

  • February 1, 2024
  • 1 reply
  • 32 views
H
Level 2
Forum|alt.badge.img+5

Hello community, nice to greet you.

 

In my project the need arose to join several columns into one.

 

In addition I need to create a calculated field that adds the amounts that match the same description in different column, i.e. I need to add the 1223 that belong to "incomplete documentation" in the first column plus the 854 that belong to "incomplete documentation" in the second column.

 

I have tried to make a distinct function but it does not work.

 

Have any of you had a similar case?

 

I hope you can help me, if more details are needed I will be happy to help.

1 Attachments

    1 reply

    L
    Level 0
    Forum|alt.badge.img+6
    • lea.hanna12
    • Level 0
    • February 15, 2024

    Hello Hector, 

     

    At first glance I think using a CASE WHEN statement with a specific condition could work. 

    To assist you further in your specific case, could you please share some more details such as the table name where each of your dimensions is coming from. E.g. table name\\s where 'SUBTIPIFICACION1' & 'SUBTIPIFICACION2' are coming from ? Also, is Folios a dimension from a table, or is it derived from a calculation in the PQL ? Finally, could you please provide more information on the columns you’d like to join into one, and the kind of format you are looking for ?

     

    Thanks In Advance

     

     

    Community Code of ConductAccessibility statement