When I try to specify join criteria like this:
from_dataset("Eligibility", "Id", MemberId: MemberId)
it outputs errors:
ClaimId,EligibilityId
1000004,error: Please use field(‘MemberId’) to access MemberId because it starts with an upper case letter.
1001007,error: Please use field(‘MemberId’) to access MemberId because it starts with an upper case letter.
…
When I change the join criteria as suggested, it outputs different errors:
from_dataset("Eligibility", "Id", field('MemberId'): MemberId)
ClaimId,EligibilityId
1000004,“Syntax error in formula 'from_dataset(”“Eligibility”", ““Id””, field(‘MemberId’): MemberId)’"
1001007,“Syntax error in formula 'from_dataset(”“Eligibility”", ““Id””, field(‘MemberId’): MemberId)’"
…
There is a test schema here: Test Data Set Join Criteria