Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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 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';
@
Beautiful.TY SO MUCH.