Hello
We have a list of values, that we need to compare to an existing dimension, and if there is an exact match, return 1 if no match, return zero.
The list of values would change daily
The list of text formatted values would be dimension: SANUM
The dimension we would be looking to compare to is PRODNUM
in layman's terms
IF(SANUM=PRODNUM,1,0)
below is a sampling of the custom list (SANUM)
| 3MMM461 |
| 3MMM7000028852 |
| 3MMMGB12 |
| ABCI222004931 |
| ABCI222006931 |
| ABCI222034931 |
| ABCI222036931 |
| ABCI2220549 |
| ABCI222092931 |
| ABCI222094931 |
| ABCI5322 |
| ABCI75129 |
| ABCI75169 |
below is a sampling of the values in PRODNUM
| 3MMM461 |
| 3MMM7000028852 |
| 3MMMGB12 |
| ABCI222004931 |
| ABCI222006931 |
| ABCI222034931 |
| ABCI222036931 |
the resulting table would have the expected results as
| SANUM |
MATCH |
| 3MMM461 |
1 |
| 3MMM7000028852 |
1 |
| 3MMMGB12 |
1 |
| ABCI222004931 |
1 |
| ABCI222006931 |
1 |
| ABCI222034931 |
1 |
| ABCI222036931 |
1 |
| ABCI2220549 |
0 |
| ABCI222092931 |
0 |
| ABCI222094931 |
0 |
| ABCI5322 |
0 |
| ABCI75129 |
0 |
| ABCI75169 |
0 |
