aggregating columns

Question

Hello,

the ingestion shows several columns as follows:

company product Name actual planned

---

...

abc pp Arrival Date 1500 null

...

abc pp Despatch Date 1500 null

...

abc pp Arrival Date null 1500

...

abc pp Despatch Date null 1500

Question

---

How can I display it like this:

company product Name actual planned

---

abc pp Arrival Date 1500 1500

...

abc pp Despatch Date 1500 1500

please note that I currently use the aggregate transformation as follows but it only shows:

company product Name actual planned

---

abc pp Arrival Date null 1500

the way I use the aggregate at present is:

group by: company, product
in the aggregates tab I use:

Answer 1

Hi @arkiboys

Thank you for reaching out to the community forum with your query.

To display the data in the format you require, you can use the MAX function in the aggregate transformation. Here's how you can modify your current aggregate transformation:

• Group by: company, product
• In the aggregates tab, use the following expressions: Name: actual, Function: MAX Name: planned, Function: MAX

This will display the data in the format you require:

company  product  Name          actual  planned
abc      pp       Arrival Date  1500    1500
abc      pp       Despatch Date 1500    1500

I hope this helps! Let me know if you have any further questions.