Need Data like this

vipin_mishra479 — Sat, 16 Nov 2024 01:07:25 GMT

No we can say like this

I have a two table

Table 2

BI Patient ID	BI Service Request Type	BI SR Created Date	BI CaseNumber
PAT-188149	Benefits Investigation/Prior Authorization	4/4/2018	1118864
PAT-188149	Benefits Investigation/Prior Authorization	6/4/2018	1118865
PAT-188149	Benefits Investigation/Prior Authorization	4/6/2019	18197

Now we need to check some condition like

we need to bring all BI record into the table with this condition my BI SR Created date is less then SR Created date Below is the out put

Patient ID	Service Request Type	SR Created Date	CaseNumber	BI Service Request Type	BI SR Created Date	BI CaseNumber
PAT-188149	GATCF Patient Assistance	4/19/2016	435031
PAT-188149	GATCF Patient Assistance	4/9/2018	1125219	Benefits Investigation/Prior Authorization	4/4/2018	1118864
PAT-188149	Patient Foundation	12/8/2018	1634660	Benefits Investigation/Prior Authorization	6/4/2018	1118865
PAT-188149	Patient Foundation	6/25/2019	2151894	Benefits Investigation/Prior Authorization	4/6/2019	18197

topic Need Data like this in QlikView