fred | Ruby wrapper for the St. Louis Federal Reserve Economic Data | REST library

I have an array of objects like this:

I'm trying to generate some data for testing by duplicating existing data in my database. There are a number of tables linked by FKs and I want to keep the same data profile. I think it's easiest to explain with an example:

I want to duplicate all the customers who are older than 18, including all of their linked data. So for the Customers table it's easy enough to do something like:

In Excel I want to post an array of 6 values to each row of an Excel worksheet, one array at a time, starting in the first column and move down the sheet a row at a time as I do this, using an index. I start at row 2, to allow for column headings.

I based my code on other code I have used in the past but it generates a compiler warning, with the line TargetRange = TargetRange.Cells(i + 1,1).Resize(1, 6).Value = Arr.

I cannot see how to use the index to step through the rows on the sheet. What should I do please?

Here is the simplified code I am using.

The following code works fine when HD is placed anywhere but right before the return statement. When HD is placed between D and the return statement, it gives an AttributeErrror. The same goes for the N variable - if I place it down the bottom, it doesn't work. I'm sure there's a good explanation for this that I'd love to learn if anyone would have a moment.

Works

I am searching for a method (package) that enables me to 'drop' a row from one table on a row in another table. The server-side functionality that I am envisioning with it is that I can create some logic that will update the destination table. Unfortunately, I have not been successful prototyping this with the packages with the available shiny packages I could find.

The idea of the MVP concept in the code below is to assign (with drag 'n drop on) one of the callers in the top table to a row in the second table.

The closes I have come to it, is the following:

I have two arrays that I would like to compare against each other based on the Username and create a new array that includes EmployeeName

Why I can't print third element of my vector ? I'm need a words that will be divided to vector and after that, they will be printed. But my third element of vector isn't showing in the terminal.

I have simple UDF which returns a value based on the input parameters and if the parameters are empty its not returning the default case . Appreciate any help in correcting my understanding

I am trying to raise an exception when an invalid role is given to my function. My code is as follows