Table A and Table B, common fields to be shown when selected Yes and no related to be shown when selected N

[SK28]

Hi 
I have table A and table B, as shown below

TableA:
Business
A
b
c
d
e
f


tableB:
Business
A
b
g
h
i

I need an output and I need to create a column as FLAG which has Yes and NO fields in it, 

if a user selects YES 
output
A
B
has to be shown 

if a user selects NO
c
d
e
f
g
h
i

[ramchalla]

Hi,

Please check the attached qvw if this helps.

TableA:

LOAD * Inline [

Business

A

b

c

d

e

f

];

tableB:

LOAD * Inline[

Business

A

b

g

h

i

];

FinalTable:

NoConcatenate

LOAD * ,

if(Match(Business, 'A','b'), 'YES','NO') as FLAG

Resident TableA;

DROP Table TableA;

[SK28]

 Hi this is what I have done is there any other way doing this ? Thanks for the response @ramchalla 

[ramchalla]

Hi @SK28 I think you missed posting here what you did. Can you please post the missing part again?

[Chanty4u]

Try this 

TableA:

LOAD *, 'Yes' AS FLAG

INLINE [

Business

A

B

C

D

E

F

];

TableB:

LOAD *, IF(Not Exists(Business), 'No', 'Yes') AS FLAG

INLINE [

Business

A

B

G

H

I

];