Create new table

[drohm002]

Hello, please see the picture below.  I am trying to create a new table that creates a row for each day for each particular machine regardless if that machine had an exam date, and then creating a column in that table that holds the total minutes in that day.  Please help!

[Qrishna · Accepted solution]

try below:

DATA:
LOAD * INLINE [
ExamDate,Machine,
09/01/2024,VC
09/02/2024,BC
09/02/2024,VF
];

Full_Table:
Load Distinct ExamDate as Exam_Date, 1440 as Minutes Resident DATA;
left join(Full_Table)
Load Distinct Machine as Machine_ Resident DATA;

[drohm002]

thank you!