How to check the value in the both dimension by the expression?

[Rick21]

I have two dimensions. I want to check if the value of the B dimension in the A dimension return same value, or return Null. The picture below is my expected output.

So, my expression is if(B=A, B, Null()), but the output I get is the image below. How can I do to achieve my expected output?

[sidhiq91]

@Rick21  Please find below the script that I used in the Load Editor. 

NoConcatenate
Temp1:
Load * Inline [
A,
Apple,
Cat,
Orange,
];

Mapping Load
*,
'Present' as Flag
Resident Temp1;

NoConcatenate
Temp:
Load A,
Applymap('Temp1',A,null()) as Condition

Inline [
A
Apple,
Cat,
Dog,
Bird,
Pear
];

NoConcatenate
Temp2:
Load A,
if(Condition='Present',A,Null()) as Condition
Resident Temp;
Drop table Temp, Temp1;

exit script;

If this resolves your issue, please like and accept it as a solution.

[ASEDavidSu]

Hello,

Here's my solving solution. You can take it for an example.