Table formatting

[BI_Dev]

Hi - I am trying to build a table but having issue with blank cells.

Ex: I have table as below.

ID	Name	Date
1	Start	8/23/2020
1	End	12/23/2020

Load

ID,

If(Name = 'Start',Date) as StartDate,

If(Name = 'End',Date) as EndDate

From Table;

While adding StartDate and EndDate it is creating 3 Rows, one for Start, one for End and one Blank.Is there a way to have all these in 1 row as below ?

ID	StartDate	EndDate
1	8/23/2021	12/23/2021

Thank you much.

[Kushal_Chawda · Accepted solution]

@BI_Dev  try below

Data:
LOAD ID,
     Date as StartDate
FROM table
where Name='Start';

left join(Data)
LOAD ID,
     Date as EndDate
FROM table
where Name='End';

@ 

[BI_Dev]

Beautiful.TY SO MUCH.