dmi | API for the Danish Meteorological Institute | Predictive Analytics library

I am trying to use a variable to store the count in a temporary table created within a stored procedure in Snowflake so that I can include the value in the return statement. When I try to do a select count(*) from the table I get SQL compilation error: Object 'CDP_SMS.DOMAIN_CANONICAL.TEMP_DELTA_MANUFACTURER_ITEM' does not exist or not authorized.. If I try to use LET to create a variable I get the same error. If I use SET to create a session variable, it doesn't immediately error but I am unable to access the session variable afterwards (I'd guess that session variables don't work in stored procedures). Removing the temporary keyword from the create table statement does not help.

However, I am able to use the table in an update statement (lines 36-48) and it works fine. Is there a way to store the count of a table created and dropped within a stored procedure to use in the return statement? I suppose I could use the logic that creates the temp table in a subquery and directly get the count but I'd really prefer not to do that (this code is a simplified version of the query that creates the temp table and it is actually pretty unwieldy with multiple unions and joins).

I have a dataset which records patient’s each instance of hospital admission. Each record therefore has a patient id, admission date, and the date of discharge. Patients can be discharged and admitted again on same day to a separate hospital, separate ward or a patient can be admitted to a separate hospital before the initial recorded discharged date (nested transfer). I am trying to create a variable that calculates a continuous periods of hospital care which groups serial transfer (admission date is equal to the previous discharge date), overlapping transfer (admission date before previous discharge date) and nested transfer as a single episode of hospital stay. Here is the example data.

I have this table which shows me the values of RSI, ADX, DMI+ and DMI-. However, after the comma I have 10 number, but I want only 2 after it. How can I make this happen?

I'm trying to select a local file based on what motherboard version exists on the machine on which Ansible will deploy those files.

So my approach was to use dictionary in format {"" : ".yml"}. And use this dictionary to populate a new variable (pcu_config here) that will finally store the name of the file to be used by ansible. I've gotten so far as shown in my implementation, and I'm get undefined variable error at line

I already have a pine-script running DMI, Stochastic RSI and RSI together successfully. But I have found a community script of DMI which gives better and smoothed signal. But while I am trying to add the new DMI it is giving the following error -

Add to Chart operation failed, reason: Variable SmoothedTrueRange is already declared.

My code is as follows -

I am trying to add Stochastic RSI, DMI and RSI together in trading view, but encountering this following error - "Add to Chart operation failed, reason: line 39: 'src' is already defined."

My code is as follows -

I made a indicator in Pine Script that shows a red or a green diamond, whenever all the conditions are met. However, as long the conditions are valid, pine script prints out on every candle a diamond.

The script works by using 50 and 200 EMA, DMI+/- and ADX, RSI

See reference image: Multiple red/green diamonds

I want it to only show me for example one red diamond until a green appears and not multiple red ones in a row.

Here is the code:

I am trying to add DMI, RSI and RVI in one script. But encountering the following message - Add to Chart operation failed, reason: line 16: 'len' is already defined. Add to Chart operation failed, reason: line 22: 'len' is already defined.

My code is as follows -

I am trying to read in multiple excel spreadsheets in which the data is organized into tables. (Example of what the spreadsheet looks like currently in the image):

Data in Excel to be transformed in R, has repeated tables

I need the experimental unit (cow) as its own column in analysis, but it is only located in the header of each table. Any ideas of the best way to rearrange the data in R? The first row of the spreadsheet is also read in as the column names, which I obviously don't really want either. Here is a reproducible example of what the sheet looks like when read into R: