[FAQ000182]When I output data using the "Aggregate and output data from table []" action, blank rows appear. What should I do?

Q

When I output data using the "Aggregate and output data from table []" action, blank rows appear. What should I do?

A

If you set "[Target item] is not empty" in "Refine condition before aggregation", records with unregistered target items will be excluded from the aggregation.

Please refer to the following help as well

[FAQ000137]What does the "Aggregation key" in the "Aggregate table data and output" action specify?

[FAQ000138]What is the difference between "Refine conditions before aggregation" and "Refine conditions of aggregation result" in the "Aggregate and output table data" action?

In addition, an extension option, SQL Actions, is available to write SQL statements directly.

Please refer to the help below.

SQL action