Summarize a Union of Tables

[ratercero]

Hi, 

Looking to summarize a union of 2 tables by Machine 3 and assigned date here is my union code:

OEE_TRANSIT = 
UNION (
    SELECTCOLUMNS (
        t_Batch,
        "Machine #", t_Batch[c_MachineId],
        "Assigned date", t_Batch[ASSIGNED_DATE],
        "RUN_HOURS", t_Batch[RUN_HR_DAY1],
		"SET_HOURS", t_Batch[SET_HR_DAY1],
		"BATCH_HOURS", t_Batch[BATCH_HR_DAY1]
    ),
    SELECTCOLUMNS (
        FILTER ( t_Batch, t_Batch[DAY_1] <> t_Batch[DAY_2] ),
        "Machine #", t_Batch[c_MachineId],
        "Assigned date", t_Batch[DAY_2],
        "RUN_HOURS", t_Batch[RUN_HR_DAY2],
		"SET_HOURS", t_Batch[SET_HR_DAY2],
		"BATCH_HOURS", t_Batch[BATCH_HR_DAY2]
    )
)

I get this error when i try to summarize it:

thanks for the help

[Greg_Deckler · Accepted solution]

Looks like it wants you to have an aggregation for 

t_Batch[BATCH_HR_DAY1]

like SUM(t_batch[BATCH_HR_DAY1]) ? 

[ratercero]

thank you @Greg_Deckler, It worked! is there a way to do this in "1 step"  instead of having a middle table as Im using??

[Greg_Deckler]

Depending on your data source, you could write a SQL union statement or use an Append/Merge query perhaps.