Case Statement or Formula for creating a flag
I have to create a flag in a dataset where
(IF columns A.a and B.a = A.b and B.b ) then I have to check cols A.c = B.c or A.d = B.d
My Data is like
Can someone help me in case statement. The one I have is not showing correct results. First two columns have to match to figure out discrepancies in next cols. If cols match it is 1 and if c and d cols are not matching then its 0.
0
Comments

CASE WHEN `A.a` = `B.a` AND `A.b` = `B.b` THEN CASE WHEN `A.c` = `B.c` AND `A.d` = `B.d` THEN 1 ELSE 0 END END
This will return NULL if A.a and A.b do not equal B.a and B.b resepctively.
1 if c and d match and a and b match
0 if they don't but a and b match
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
 All Categories
 1.2K Product Ideas
 1.2K Ideas Exchange
 1.3K Connect
 1K Connectors
 267 Workbench
 Cloud Amplifier
 3 Federated
 2.5K Transform
 78 SQL DataFlows
 524 Datasets
 1.9K Magic ETL
 2.9K Visualize
 2.2K Charting
 433 Beast Mode
 22 Variables
 507 Automate
 113 Apps
 386 APIs & Domo Developer
 8 Workflows
 25 Predict
 9 Jupyter Workspaces
 16 R & Python Tiles
 331 Distribute
 76 Domo Everywhere
 255 Scheduled Reports
 65 Manage
 65 Governance & Security
 1 Product Release Questions
 Community Forums
 39 Getting Started
 25 Community Member Introductions
 67 Community Announcements
 4.8K Archive