Hi All,
Is it possible below Output. Required output is Required logic need to Find Single value and Assign a flag 1 and 0.
| Data | A3&";"&B2 | Required Output |
| Apple | | |
| Apple | Apple; | 1 |
| Orange | Orange;Apple; | 1 |
| Orange | Orange ;Orange;Apple; | 0 |
| Orange | Orange;Orange ;Orange;Apple; | 0 |
| Orange | Orange;Orange;Orange ;Orange;Apple; | 0 |
| Banana | Banana;Orange;Orange;Orange ;Orange;Apple; | 1 |
| Banana | Banana;Banana;Orange;Orange;Orange ;Orange;Apple; | 0 |
In Above table Find Single value and assign 1 flag like 2nd row Apple. Thanks In Advance.
