Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BI_Dev
Creator II
Creator II

Table formatting

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

Ex: I have table as below.

IDNameDate
1Start8/23/2020
1End12/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 ?

 

IDStartDateEndDate
18/23/202112/23/2021

Thank you much.

Labels (6)
1 Solution

Accepted Solutions
Kushal_Chawda

@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';

View solution in original post

2 Replies
Kushal_Chawda

@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
Creator II
Creator II
Author

Beautiful.TY SO MUCH.