I have a list of 300 code combinations in the following format, which I plan to load into a global
X123, Internal health
X234, external health
X345, Peripheral health etc..
I want to get the code from the DG1 segment, compare to the global, and add a description. Is there an easy way to do it?
So in my DG1 segment If I get the code X123, what I want to do is check if the code is in the global and if it does add the description in the field.
So DG1 will look like this:
and needs to be transformed as below
DG1|1|CDS||X123^Internal Health^^|20200827141200|Primary||||||||||Dr. Who|||