MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test_t(Table_c varchar(500), data_c varchar(500))
insert into test_t values('table A', '{"name": "F", "action": "ADDED"}');
insert into test_t values('table B', '{"action": "UPDATE", "DISABLED": "0", "fieldType": "String"}');
Select * from 
(SELECT CASE WHEN Table_c = 'table A' THEN
            CONCAT_WS('\n','Name: ', JSON_EXTRACT(data_c, '$.name'))
        END AS 'TableA'
from test_t) A
,
(SELECT CASE WHEN Table_c = 'table B' THEN
            CONCAT_WS('\n','Location: ', JSON_EXTRACT(data_c, '$.fieldType'))
        END AS 'TableB'
from test_t) B
where TableA is not null 
	and TableB is not null 


TableA
TableB


Name: 
"F"
Location: 
"String"


SELECT CASE WHEN Table_c = 'table B' THEN
                 CONCAT_WS('\n','Location: ', JSON_EXTRACT(data_c, '$.fieldType'))
            ELSE
                 CONCAT_WS('\n','Name: ', JSON_EXTRACT(data_c, '$.name'))
       END AS 'Data'
       , CASE WHEN Table_c = 'table B' THEN
                 'Table B'
            ELSE
                 'Table A'
         END AS 'Table'
from test_t    


Data
Table


Name: 
"F"
Table A

Location: 
"String"
Table B