SJM | related jobs running on a compute cluster | Job Scheduling library

I'm trying to parse property information from this link which produces a JSON response. I've used here JSON and VBA converter. However, when I run the script below, I get an error keyNotFoundError. I'm trying to parse the value of properties which is within features.

I've a table structure where I'm saving the data in the below format.

The ledger amount needs to be divided into two columns and grouped through the sum equation.

Those rows having receipt_id not as null their ledger_amount needs to be displayed as sum(ledger_amount) as credit whole rows having payment_id not as null their ledger_amount needs to be displayed as sum(ledger_amount) as debit

These values need to be grouped using the "month-year" fetched from the date from the receipt_master and payment_master tables using join using the "date period".

I'm quite successful in developing the overall query except one minor glitch.

When I use the "group_by" query on "month-year" it sums up all the record of the particular month in either debit/credit depending on the higher number of rows in the particular criteria, which I want to be separate.

Check this image.

I've not yet applied group_by month on this currently, it is showing individual records perfectly.

See below what happens when I apply group_by via month.

It sums up all the ledger_amount values and display it on the debt side as 53819.00 instead of showing 19500.00 on credit side and 34319.00 on the debit side

Below are my queries for the above results.

Query for the 2nd Image

I am currently attempting to run a for loop on about 500 stock tickers and attempting to create a chart for all of them. I have succeeded in doing this but my for loop breaks on this error Error in runSum(x, n) : n = 20 is outside valid range: [1, 5] I got the stock tickers from BatchGetSymbols library.

Here is my script at the bottom is my for loop:

Here,I am creating a list called li which has tag text and list called list2 that has span text.I am appending it using zip .Now,I have a third list called name which has 2 values (Most Actives,Gainers).I want Mostactives and then first 10 values from a list,then the gainers and next 10 values.The sample output is shown below.

The code below is for scraping data from webpage.Actually,the output from this code
and output from the another list is to be considered .

I have some data which looks similar to the following:

This is somewhat of an addition/side question to one I am asking here but the question is different.

I would like to know where I am going wrong with my code in regards to mapping over nested tibbles. The data can be generated using:

I have an array of arrays in javascript. And want to perform some kind of calculations.

My array looks like on the picture below:

Where: - First value is a code. - Second value is a size. - Third value of each array is a count.

What I'm trying to do, is to find all groups, where all counts are 0.

For example:

• If "NVY" "S" - will be 0 (not 28) I want to return:["sjm-NVY"];

What I have tried:

How to write SAS dates to Microsoft SQL Server 2016 Date data type in database?

I got SAS data with a sas date DataEndDay and I want to write that into a database. The following bit is in use (buffer is just to speed up the testing-failing) :