w5 | Security Orchestration , Automation and Response | Security library

Im currently working on an MVC project and need to get the postal code based on the users address. I have been able to successfully get the latitude and longitude but can't figure out how to extract the postal code from the xml response.

Here is the XML im working with which is the sample XML they use on the api documentation page.

function sum(boolean) does not exist LINE 13: ISNULL(SUM(s.Offset = 0), 0) w1, ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

I'm trying to create a weekly cohort analysis that would show the weekly login stats. As you can see this is what I want to achieve:

This is what I have found, and what I'm trying to re-create:

http://sqlfiddle.com/#!9/172dbe/1

These are the tables that I'm trying to take the data for:

And this is what I have refactored so far:

First, thanks for reading this! Second, I have no control over the .txt file that I am getting my data from. I'd like to be able to take the data and separate it into Complete Matches and then show those results then Upcoming Matches and show those.

For Example:

Most Recent Completed Matches

I am currently in the process of learning myself, Power Bi. However, I got myself stuck when I tried to summarize a result based on the last X rows instead of filtering the last X dates. In order to have a better understanding here is the table that I created:

Hello friends, I have been working on this all night and really don't understand what I am missing. I understand that the problem is in the addWord() method but I don't understand how. I tried removing the checkword() method from the addword() method and I also removed the .trim() from the string declarations for w1 and m1. I did not include the XML becuase of the character limit but i am sure the initializations are fine. Would really appreciate it if you can help a noob out. thank you

The Error:

I'm interested in visualizing the location of certain words in sentences. Say I have 500 sentences between 3-5 words long and want to visualize the location of word A in each sentence:

Data:

For a large data set I am trying to insert missing weeks for each each customer ID with their corresponding amount to be 0. The week starts from w3 and goes up to w7.

I am trying to bring up an on-prem k8 cluster using kubespray with 3 master and 5 worker nodes. The node IPs are from 2 different subnets.

Ansible inventory:

I have dataframe which looks like.