metals | Scala language server with rich IDE features 🚀

So i got a page with a series of switches that are based on the following values:

Im creating a medical app and i got a react class that uses hooks and looks like this.

My apologies for being back so soon. I've tried many ways, but I can't compile the code because everything I've tried tells me I can't do that with a boolean field. Every example I've searched gives examples for ? x == 1. But I'm trying to filter for a field that has a boolean value ? x == true.

I've tried filtering in the foreach loop, changing to a for loop, adding a condition to the where also to the join and a RemoveAll. I can't find/think of any other ways to try. Inexperience is killing me.

I need to filter catObj.["IncludeCategory"] == true.

Any help is appreciated.

I want to join two json files using a common key and get all the records from the right file and matching data from the left.

If it was SQL.

I have the following data frame:

I wanted to use Java's java.lang.Thread in my Scala project, so I imported it, and wrote a statement: Thread.yield(). However, Metals immediately pointed out that yield is a reserved keyword. Then, what identifier should I use to refer to java.lang.Thread.yield()?

I have created a table that contains content from an array of objects.

I have data from multiple suppliers which I wish to compare. The data shown in the image below has been previously transformed via a series of steps using power query. The final step was to pivot the Supplier column (in this example consisting of X,Y,Z) so that these new columns can be compared and the maximum value is returned.

How can I compare the values in columns X, Y and Z to do this? Importantly, X Y and Z arent necessarily the only suppliers. If I Add Say A as a new supplier to the original data, a new column A will be generated and I wish to include this in the comparison so that at column at the end outputs the highest value found for each row. So reading from the top down it would read in this example: 3,3,1,1,5,0.04,10 etc.

Thanks

Link to file https://onedrive.live.com/?authkey=%21AE_6NgN3hnS6MpA&id=8BA0D02D4869CBCA%21763&cid=8BA0D02D4869CBCA

M Code:

Background: The table below contains example data from relevant documents (the names of documents are MSDS, RMQ, COA, Technical Data sheet) for materials A,B,C etc. The information from these documents includes the date, Heavy Metal impurities and Residual Solvent impurities and their amount in ppm (parts per million).

Using power query I have sorted this data so that the 2 tables shown in the image below are produced.

These containing the highest amounts of heavy metals (blue) and residual solvents (yellow) found across the documentation as well as source of the document containing this value. To replicate the spreadsheet I have provided the (quite extensive) M code at the bottom. Very Briefly though for this problem; "Heavy Metals" and "Residual Solvents" are phrases used as delimiters to split the data accordingly.

Minor Problem: Although pleased with how the table functions, I didn't feel that the 'splitting of a split column' (see M code) is an entirely satisfactory solution to separate the data. Subsequently I've realised that If a cell were to accidently not include "Heavy Metals" as a delimiter the logic would cause the Residual Solvent data for this cell to be lost (as is the case for Cell 4E (Material C, technical data Sheet)).

I may just insist to those using this spreadsheet to ensure these phrases are always present however I wanted to ask here to see if anyone had any clever alternatives to the M Code provided so that although the Heavy Metals may be missing without the delimiter (or if spelled incorreclty), the Residual Solvents are still pulled through.

I appreciate that this is rather a tasking job for someone to look at, and fortunately it is a relatively minor issue so any advice would just be a bonus. I also just through it was quite quite interesting to show how power query can be used to split seemingly complex data within a cell. Also please note that the Data in the table is 'messy' to test if this causes any problems.

M Code: This is the Code for just the Residual Solvents Table. Power query splits the data into heavy Metals and Residual Solvents and then depending on the table removes the appropriate columns.