table-for | table builder for an array of objects | Grid library

Assume that I have a table of products and that there are only 2 fields; id and purchase_date. I want to delete the last product that was bought in 2019. I have tried to do it using the following query:

I have a Python code that is creating HTML Tables and then turning it into a PDF file. This is the output that I am currently getting

This image is taken from PDF File that is being generated as result (and it is zoomed out at 55%)

I want to make this look better. Something similar to this, if I may

This image has 13 columns, I don't want that. I want to keep 5 columns but my major concern is the size of the td in my HTML files. It is too small in width and that is why, the text is also very stacked up in each td. But if you look at the other image, text is much more visible and boxes are much more bigger width wise. Moreover, it doesn't suffer from height problems either (the height of the box is in such a way that it covers the whole of the PDF Page and all the tds don't look like stretched down)

I have tried to play around the height and width of my td in the HTML File, but unfortunately, nothing really seemed to work for me.

Edit: Using the code provided by onkar ruikar, I was able to achieve very good results. However, it created the same problem that I was facing previously. The question was asked here: Horizontally merge and divide cells in an HTML Table for Timetable based on the Data in Python File

I changed up the template.html file of mine and then ran the same code. But I got this result,

As you can see, that there were more than one lectures in the First Slot of Monday, and due to that, it overlapped both the courses. It is not reading the

The modified template.html file has this code,

This question is in relation to my previous problem which was solved. Link to Previous Problem

Now I need to access columns and values of the Tag "GetCustomReportResult" and transform into a SQL Table format.

The JSON String is actually stored in a column in a SQL Table as seen below and I am trying to transform the elements in the tag "GetCustomReportResult" in a table format with columns and values for each of the "ApplicationID":

Here is what I was trying to access the columns and values within the Tag "GetCustomReportResult":

I want to address the table-formated output of my function like an object, i.e. the row [2] column 'Action' should be addressable like $r[2].Action. How can I do that?

I tried using 'ConvertFrom-SourceTable' from the powershellgallery, but that didn't work. And I'd rather have a simple solution without extra installs.

When a foreign key constraint is placed on on a MySQL table, an index is automatically added by MySQL for better performance. I'm totally ok with this. It's all in the docs.

But, when deleting the foreign key, I noticed that the auto-created index itself is not deleted. And that's not in de docs. I'm wondering:

1. Will it get ever deleted automatically, since MySQL did create it for me too?
2. How large can a foreign key index get? If it's only a few kilobytes, I'm not bothered, but what if it gets large...?

https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html only says this:

MySQL requires indexes on foreign keys and referenced keys so that foreign key checks can be fast and not require a table scan. In the referencing table, there must be an index where the foreign key columns are listed as the first columns in the same order. Such an index is created on the referencing table automatically if it does not exist. This index might be silently dropped later if you create another index that can be used to enforce the foreign key constraint. index_name, if given, is used as described previously.

I'm trying to change my icon to white

Here is my current code but not sure how to change icon colour property:

Link to codesandbox sample

This powerful custom fnGetParameter function lets you dynamically inject file names into your queries.

But because of it, the Data source settings show Current Workbook instead of your actual imported files:

Thus, as many have commented in that link it can lead to this message, for example if I try to Merge Queries i.e. Table.NestedJoin():

Formula.Firewall: Query '{name}' (step '{step}') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

Sample data

cities.csv

cars.csv

Excel itself

table name=Parameters

cities query

I'm creating a basic small Table in chakra-ui, however the whitespace between columns is too much for my particular use case. I've set size="sm" but it's still too much whitespace.

How can we achieve this? Here's a summary snippet of pseudo-code corresponding to my problem:

I have almost 1,800 Word documents that have about 8 pages with unique data in tables. We were just informed that the data we were given for some of those tables is inaccurate and needs to be changed from "N/A" to "0.0%". As "N/A" is used a lot in the document, I unfortunately cannot just find/replace that text.

Using this thread (Macro to find in Word table for specific string in a cell and move x cell left, check isnumeric then set typography on down x cell in the same column) I was able to adjust the code below to find the column header (On-Time Completion Rate) and move to the adjacent cells to update them. However, since this column is for percentages, the IsNumeric code is changing any data it finds due to the percentage symbol.

Is there a way to do the same but instead of using IsNumeric (since it does not work for percentages) check the value in the cell and if it finds "N/A" change it to "0.0%"? This would then need to be repeated for two more tables, with one table have four rows to look through.

Thank you in advance for any help you can offer!

Screenshot of table