Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Small Backend Issue help

Hi Experts,

Can any one please help me to get all the below rows in straight table into one row like below expected output

Expected output from image

ID                  Hire Date        Training1 Com Date    Training2 Com Date      Training3 Com Date           Training4 Com Date

68064            22/03/1999     20/02/2018                    13/07/2018                        08/03/2018                           -

Dates table.png

Here all the above fields are dimensions in the backend. The script is

Load

ID,

Hire Date,

if(Training = 'Training 1', [Completion Date] )    as  "Training1 Com Date",

if(Training = 'Training 2', [Completion Date] )    as  "Training2 Com Date",

if(Training = 'Training 3', [Completion Date] )    as  "Training3 Com Date",

if(Training = 'Training 4', [Completion Date] )    as  "Training4 Com Date"

From  [lib://Source/Training.qvd] (qvd);


Please help me to get one row per one id in the backend.


Thanks in advance



1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Small Backend Issue help

Hi,

you will have your required output if you will join tables one by one.

Table:

Load

ID,

Hire Date,

if(Training = 'Training 1', [Completion Date] )    as  "Training1 Com Date"

From  [lib://Source/Training.qvd] (qvd);


Left join (Table)

Load

ID,

if(Training = 'Training 2', [Completion Date] )    as  "Training2 Com Date"

From  [lib://Source/Training.qvd] (qvd);


Left join (Table)

Load

ID,

if(Training = 'Training 3', [Completion Date] )    as  "Training3 Com Date"

From  [lib://Source/Training.qvd] (qvd);


Left join (Table)

Load

ID,

if(Training = 'Training 4', [Completion Date] )    as  "Training4 Com Date"

From  [lib://Source/Training.qvd] (qvd);



Hope that helps

View solution in original post

2 Replies
Highlighted
Luminary
Luminary

Re: Small Backend Issue help

If you uploaded a sample of your raw data, it will be easier for us to help.

Highlighted
Creator III
Creator III

Re: Small Backend Issue help

Hi,

you will have your required output if you will join tables one by one.

Table:

Load

ID,

Hire Date,

if(Training = 'Training 1', [Completion Date] )    as  "Training1 Com Date"

From  [lib://Source/Training.qvd] (qvd);


Left join (Table)

Load

ID,

if(Training = 'Training 2', [Completion Date] )    as  "Training2 Com Date"

From  [lib://Source/Training.qvd] (qvd);


Left join (Table)

Load

ID,

if(Training = 'Training 3', [Completion Date] )    as  "Training3 Com Date"

From  [lib://Source/Training.qvd] (qvd);


Left join (Table)

Load

ID,

if(Training = 'Training 4', [Completion Date] )    as  "Training4 Com Date"

From  [lib://Source/Training.qvd] (qvd);



Hope that helps

View solution in original post