-
Time Format
Hello, I am combining date and time in one column but once is combined the date format is ok but my time format is all zeros. is there something I am missing? Thank you!
-
Updating Datasets
Hello, My datasets were moved to a different server and now I need to point all my dataflows/cards to the new dataset. Before I do can someone please guide me with the following questions: Is there a way to change the datasets in one place vs going thru each dataflow? My predecessor applied some of the beast modes to the…
-
Creating a new column
Hi all- I am having some issue separating a column. My data set has the payors in the same column and I need to create a separate column for each payor. Can someone please help ? Thank you
-
Distinct patients that need to schedule a follow up appointment
Hello , I am trying to figure out which patients did not schedule a follow up appointment after their last visit. I want to show last Kept visit per patient and if the patient needs to book an appointment . The problem i am having now is that one patient can have several Kept visits. . I want to show their last 'K' (kept)…
-
Magic ETL error message
Hello, can someone help me figure out how to fix this error in my ETL "failed to convert data '$0.00' to type BigNumber for column 'Gross charge' Thank you.