Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried this:
CPT:
LOAD [Unique Identifier],
[CPT_1] as CPT
RESIDENT Claims;
CPT:
LOAD [Unique Identifier],
[CPT_2] as CPT
RESIDENT Claims;
CPT:
LOAD [Unique Identifier],
[CPT_3] as CPT
RESIDENT Claims;
All the fields would appear in one list, but the search process did not work.
When I load the data is there someway I can merge the columns and separate them with a delimiter?
load
field1 & '-' & field2 as newfield,
.....