fluffy | A file-sharing web app that doesn't suck | File Sharing library

Say I have a new table like such where there is no values yet:

and i have a populated table like such where it has values that i want to correlate to the new empty table:

what i want to do is take each "format" from table 2 and create a new column in table 1 where "status" from table 2 is the value of the new "format" column in table one. Here is what i want the table to look like assuming the above tables are what im working with:

The extra tricky part is in table 2, uuid1 can have more or less "format" values than say uuid2 and visa versa continuing on to like 50k uuids so i need to fill the other columns with a null or falsey value

Is this possible or am I working with too ridiculous of data to make it happen?

When attempting to import XML data using an SSIS package, I keep getting this error :

The XML Source was unable to process the XML data. The Xml source document contains multiple "CaseCode" elements and maxOccurs=1 was specified in the Xml schema.

I'm using the following sample data:

I'm trying to get the split() method to split at a list or string of one character.

Here's the program I was trying out before I came here:

What I Want:

I am trying to make it so when a member is added or removed from staff in my discord it will update it on the website I have. I've tried doing this with node.js, but then I can't use document attributes and etc. Basically I am wondering if this is possible.

Code JS:

I have a dataframe where column Name contains values such as the following (the rest of the columns do not affect how this question is answered I hope):

What are the differences in hide(), show() and .addClass in these two examples, and why does .addClass not work in the second example?

These two examples are simple jQuery search functions that use :contain to find the search terms in the .record divs.

This example works with hide() and show().

I am making a simple app where it displays some recipes and you can go into an individual 'recipe screen' which shows an image/ingredients and instructions for making the recipe. However I am now trying to make a button which returns you to the recipe list. The button works however the recipe screen and the recipe list which I am returning to seem to overlap, therefore I need to figure out how to clear the recipe screen before moving to the recipe list screen. However, for some reason the clear_canvas() or clear_screen() functions do not work. What should i do instead in order to clear the kivy screen?

This is an image of the overlapping screens:

Python code:

I'm currently using postgres, accessing it through a node server.

I'm feeling stuck on how I would search for a specific term within a table in order to make a change. I know I can SELECT certain items, but I don't know how to search within the items.

say my table is:

Suddenly, I get bit by a dog, and now I want to change everything containing 'dog|Dog' to scary: yes.

I can't really find any good resources to create the function. Perhaps I've overlooked something.

Right now I'm using simple SELECT's like this:

I have to make a function that takes dictionary (object) and sentence as parameteres and returns adequete key's value and if there is missing word in a dictionary function should throw an error "Error: missing value"

these are examples of output:

translate({ "je": "I", "suis": "am", "pere": "father", "ton": "your"}, "je suis ton pere" ) // 'I am your father'

translate({ "the": "le", "cute": "mignon", "your": "ton", "dog": "chien", "is": "est"}, "the dog is cute" ) // 'le chien est mignon'

translate({ "the": "le", "cute": "mignon", "your": "ton", "dog": "chien", "is": "est"}, "the dog is fluffy" ) // 'Error: missing value'

my code is like that: and its working but it stops at index 0, so i can get only first result which is "I"