I have raw data from hospital in which all the date fields are randomized (doesn’t follow any order for the same purpose). None of the dates in any of the table match with other related tables. All dates are unique and in future like 12/30/2900. However, I would like to generate a cohort using Atlas but it fails due to the reason that Primary criteria in Atlas has certain mandatory observation period start and end dates.
I tried different combinations of drop down values with Atlas for dates but cohort generation fails.
Am I right to understand that when there are zero results returned from SQL, cohort generation would fail. Because I tried running the Atlas generated SQL part by part and was able to see that it returns zero records for the date condition in “Where” clause (op.start date, op.end date)
So the only solution for this would be to create a dummy table with valid dates? Because, we would like to run a demo using our data in atlas. Any inputs is highly appreciated
Can you guide me as to how to handle this scenario or let me know if there is any specific combination of values that can help me generate cohort?