Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi to make if condition with two different tables? this is the command
EXTRACT USERS_ROLE RUSERS_USERID USERS_FR_CCROLE IF (USERS_EFFECTIVE_TO >%_v_Cutoff%) AND (A1_USER_PROFILE.USR02_USERID <> " ") TO A2_USER_ROLES
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |