I have the following Query:
Resulting data is in the attached file. If you notice, record_ids have values in dx1, dx2, dx3 etc, and some only have value in dx1. What I want to do is add values into the first first null "dx#" field in the above query.
The values I want to add are from the following query:
substring(dxe,1,5) as e1,
substring(dxe, 8, 1) as e1poa,
substring(dxe2,1,5) as e2,
substring(dxe2, 8, 1) as e2poa,
substring(dxe3,1,5) as e3,
substring(dxe3, 8, 1) as e3poa
And the results are also in the file.
What I want to see for expected results are also included. Thanks in advance for the help!