Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vipin_mishra479
Creator II
Creator II

Data need in that way

I have data like below 

Patient IDService Request TypeSR Created DateCaseNumber
PAT-188149GATCF Patient Assistance4/19/2016435031
PAT-188149Benefits Investigation/Prior Authorization4/4/20181118864
PAT-188149GATCF Patient Assistance4/9/20181125219
PAT-188149Patient Foundation12/8/20181634660
PAT-188149Benefits Investigation/Prior Authorization4/6/201918197
PAT-188149Patient Foundation6/25/20192151894

 

How can i achieve my data like this in qlikview . 

Out put      
PAT-188149Patient Foundation6/25/20192151894Benefits Investigation/Prior Authorization4/6/201918197
PAT-188149Patient Foundation12/8/20181634660Benefits Investigation/Prior Authorization4/4/20181118864
PAT-188149GATCF Patient Assistance4/9/20181125219Benefits Investigation/Prior Authorization4/4/20181118864
PAT-188149GATCF Patient Assistance4/19/2016435031  

 

Labels (1)
1 Reply
jochem_zw
Partner Ambassador
Partner Ambassador

What is for example the logic to have 'Benefits Investigation/Prior Authorization' on the same line as:
'Patient Foundation 6/25/2019 2151894' ??