I'd like to be able to upload a .csv file, see the contents of that file in a table component, and then load the contents of that file into a temp table that I can use in a SQL query.
I'm only able to get one row (selectedRow) into there.
How do I go about getting all the rows into my temp table?
Here is what I have right now. It seems like this is something I should be able to do, since I can do this much, but I don't know what to even search for to find it in the documentation. I've been trying for a while and am getting nowhere.
Do you want to be able to select the IDs you want or put everything displayed in SQL query?
For the former, you need to enable select multiple rows for the table component -> check the data structure of your table component for selectedRow (open left panel) -> then use that in your SELECT statement.
For the latter, you can just simply use displayedData property (i.e. table1.displayedData.personid) as that would give you the entire list of ids displayed in the table.
Thank you. I want to put all of the values from the csv into the temp table. I tried the latter but then the select shows no rows. I also tried it both with and without that Enable batch querying box checked (I don't know what that does.)
I did find another way of doing it that accomplishes the task for a simple, short, one column table.
But, it doesn't work if I want more columns and frankly, it's just an awful way to do it.
Surely there has to be some sort of JavaScript thing that will do what I need it to do.