One line per invoice No

Q&A
1

I have a table in an analysis where there are two rows per case_id due to the different invoice No.
The first invoice number is for type_A while the second invoice is for type_B but for the same case_id.
So I want to have them both in one line like below.
case_id type_A Invoice No type_B Invoice No
xxxxx xxxxxx51014 xxxxxx0820

The Invoices have also alphanumeric characters so they are of type string.

how to have them in one line?

image

Thanks

2

Hi @pantelis,

Based on your question, it sounds like you are trying to use a listagg function, which is currently not possible with the UI. However, I would definitely look into this talking about the new data prep experience and the following picture below showcasing aggregation capability:

image
image199×480 33.4 KB

Hope this helps and let me know if you have any questions!

3

Hi @pantelis,

Hope everything is well with you! Just checking back in since this thread hasn’t received a response in a while. Was Luis’ reply helpful to you or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!

4

Hi @pantelis,

Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you