How to join multiple columns?

Question

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.

lea.hanna12 · Answer

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

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN