Stack Overflow
Stack Overflow

Questions tagged [excelquery]

28 questions
0
votes
1 answer

Looking for a web scraper tool to extract entire table out of web pages and put them in different sheets in excel

The first column of this table contains all the links I have to work with: https://www.metabolomicsworkbench.org/data/DRCCStudySummary.php?Mode=StudySummary&SortBy=Analysis&AscDesc=asc&ResultsPerPage=2000 From each of the links I have to download…
Wasiful Gofur
  • 1
0
votes
0 answers

How do I pass parameters to my SQL statement?

How can I use parameters to create a dynamic SQL statement? I specified two parameters "DateStart" and "DateEnd" which I want to include in my Data source's SQL statement, but I don't know what the proper way to reference them is.  My aim is to have…
King
  • 13
  • 4
0
votes
2 answers

Is it possible to schedule the data refresh of a power query in excel to refresh data at 2 specific times every day?

I built a power query in Excel that pulls data from the newest file in a shared folder. It is an "OLE DB Query" with an SQL command type (not sure if that is relevant information but thought I would include it.) The file is updated with new data…
excelguy1234
  • 1
  • 1
  • 1
  • 2
0
votes
0 answers

Text to Column tool is interrupting my conditional formatting

I have a range of data that is pulled via a query, and then I use a data range comparison to highlight data. For instance, if I pull my data in sheet 'A', and input my own data in sheet 'B', I am checking to see what data on sheet 'A' is also on…
ColonelMustard
  • 3
  • 2
0
votes
2 answers

How to "fetch first 1 row only" per IDs in 3 different columns?

I am attempting to fetch 1 row only based on unique set of IDs in another 3 columns. In my database, there are many records per date for each of a unique set of IDs in the other 3 columns (you can imagine product numbers for instance). The stock…
Zdenda
  • 69
  • 7
0
votes
0 answers

Excel query for finding duplicates when the given table is not a pattern

I'm a beginner at Excel, I managed to solve almost all the problems encountered in the past month, but here I don't know how. The required thing is to search in the table if there are more than a master with the same id (same name, same id) and if…
dan345
  • 1
  • 2
0
votes
1 answer

Format Issue on Excel Query Table

I am trying to pull the data with SQL query in excel. Query working fine and giving exact result but issue is I am passing the date variable 01-02-2005 in query and getting output -2006 (Last Column). I tried many possible ways as of my knowledge ,…
Ashok
  • 284
  • 2
  • 5
  • 23
0
votes
1 answer

Query Relative Path for Folder.Files

Excel 2016 VBA, Windows 10 I'm trying to use VBA to Get Data. I want to use a relative reference. I just want to get data from 'Raw Keyword.csv' in the same folder as the xlsm file. It never seems to recognize the relative path. I tried building it…
user2585576
0
votes
2 answers

Query Excel where Rows and Columns are reversed

How can I query an Excel file where the rows and columns are reversed / rotated 90 degrees? Can it be done with a SELECT query, or do I need to recurse the cells programmatically? It's for a .NET app, so linq or other suggestions are welcome.
pfeds
  • 2,183
  • 4
  • 32
  • 48
0
votes
1 answer

Excel VBA listobjects.add querytable error 9

I aim to get data from a csv file using an SQL request. I already made it successfully in a previous Workbook, so I copied it and modified it only on the SQL request part. I have an execution error 9 on the first line, which has not been modified…
Guillaume B.
  • 1
  • 1
-1
votes
1 answer

Transofrm excel query to google sheets

I try to convert/transform excel query to google sheets. This the code from excel: let Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type any}, {"Column2", type…
svetlinsem
  • 37
  • 5
-1
votes
2 answers

How to select more than 2 columns in =QUERY()

I was trying to copy data from Sheet1 to Sheet2 using query. But I want to select MAX(A) and all the other columns where data exists (B,C,D...etc.) and group by B. То clarify, in Sheet1 I have some similar rows which differ in col.A, which contains…
Lyuboslav Alexandrov
  • 65
  • 8
-2
votes
1 answer

Connecting Excel and Smartsheet so excel can pull the files from a workspace of Smartsheet

I am trying to determine if upgrading Smartsheet to the business tier is worth it right now. The main thing deciding this is whether I can connect all of the files from a workspace to Excel Power Query using the Live Data Connector. I have searched…
Collin Barker
  • 11
  • 1
  • 5
1
2