query

  1. J

    Inventory spreadsheet with table parameters so I can select either retail or wholesale and then a price threshold

    I'm working on a spreadsheet for our inventory. The inventory is pulled out of a SQL database called Inventory. The retail price field is called PriceRetail and the wholesale price field is called PriceWholesale. The table starts in cell A6. I have a dropdown in cell B3 so I can select...
  2. C

    Access Report Using CrossTab Quary for people

    Tyring to build a report that shows Organization and position that people are in. For example: There is a table that shows all employees (admin) and them in the respective positions Sort ORder Org Big Boss Manager Worker 1 South Group me 1 South Group vacant 2 North Group Tom...
  3. MrKowz

    [Excel 2016] Query Silent Refresh?

    Good day, everyone! I'm in an environment that is running two different versions of Excel. Excel 2016 and O365. I developed a utility which has three data connections to other Excel files, and these data connections are causing me issues. In Excel 2016, I've recently discovered that when a...
  4. A

    Retrieve data from Oracle DB using VBA Excel containing Japanese Character

    I am trying to fetch data from my oracle db using excel VBA. I have made the connection and successfully fetching the data, however my data containing japanese character is broken. It became something like "A14 ソソ: ソソソ ソ ソソ: ソソソソ (ソソソソソ)" I wonder why my data containing japanese character is...
  5. J

    Type Id and search record directly in sql

    Hi there to all Mr Excelssss men. Ok, i know we can type an sql query and bring data to our excel. What a want to do, is to type something, which in this case is an Invoice ID number, and that triggers sql query and give me back some fields. I actually have the query that brings all the records...
  6. A

    VBA code help to write a query

    I want to have a list of values, say 0001, 0002, 0003, and 0004, and have them formatted into the following text string, where the list of values populate only the bold portions of the below text. I want to have all 4 generated so I can copy/paste them into RapidSQL. Any ideas? select * from...
  7. D

    Query Summarizing Records by Week

    I have a table TTimeRecords with records including DateofJob and HoursofWork. DateofJob | HoursOfWork 1/1/19 | 6.0 1/2/19 | 8.0 1/2/19 | 6.0 1/3/19 | 7.0 1/3/19 | 8.0 I then wanted to create a query in which hours were summarized for 2019 on a weekly basis, with...
  8. T

    Correct dates inserted into incorrect fields in table.

    I have a table that has serial numbers with dates that show when a job was entered, the date it was closed and the date it was installed. The Date of the installation is on the incorrect line and I would like to have it put onto the correct line. How can I do this in Access without going thru...
  9. A

    Link Excel to Yahoo Finance

    Hello everybody, I'm trying to download financial data from yahoo finance: specifically I have all the tickers of the shares of the Italian market (circa 450 stocks) in an Excel file and I would like to extract some tables from the "key-statistics" section. I'm not very skilled with VBA and...
  10. M

    Slow refresh

    Hi, I am beginning in power Query in Excel. I have a general issue is the speed of refresh. I have something very basic code like : Source1 = Excel.CurrentWorkbook(){[Name="tblprofit"]}[Content], #"Filtered Rows1" = Table.SelectRows(Source1, each ([Sales organisation] <> null) and...
  11. M

    Get Excel formula in query

    Hi, In Query, is there any way to get the information that in the table sourced which columns have excel formulas, which columns have values? Thanks!
  12. M

    Question Query speed

    Hi, Something strange when using Queries: I found a huge speed difference between these 2 situations : Situation1: - I make a first query "query1" and I do not load the result on a worksheet1 - I make a second query "query2" which call the "query1" by basically Source1 = query1 and do some...
  13. M

    Query table not load on sheet

    Hi, I am starting to use Power Query. After query table is done, I load it to a specific sheet to get the results, then I can use again this table for further calculations. My question is: do I mandatory need to load the query table in a sheet to get the data for further calculation in excel...
  14. K

    Query Editor - Issue with coverting date format when year changes when date format is Day DD MMM e.g Sat 28 Dec

    https://imgur.com/a/2bFUSl2 At the switch over to 2020 it just shows as an error using the following #"Changed Type" =Table.TransformColumnTypes(Data0,{{"Column1", type date}, Is there an way to handle this?
  15. M

    Power Query not loading data - Stalling

    Recently I have had both relatively small power queries (180 rows, 10 lines of M code) and larger (approx. 6000 rows, 25 lines of M code) stall at the load stage. It happened first with the larger query and I thought it had to do with the size of the query. But it has now happened with smaller...
  16. M

    Importing files with variable number of columns

    I noticed something odd today and I don't know if this is new or if I just never encountered this before. I have 3 files in a folder and imported from the folder into Power Query. 2 of the files have 2 columns, 1 file has 3 columns. Power Query imported just the first 2 columns from each...
  17. M

    Power Query duplicate date error with no duplicates?!

    Excel 2016 64-bit - Suddenly my calendar file that loaded just fine is throwing errors that there are duplicate dates, so it can't join to the other DAX tables. The query appears just fine in PQ but blows up when I try to load to the Excel data model. These lines at the end don't make a...
  18. B

    How to updated statement with PtrSafe keyword

    Hi, I have posted a generic query regarding ‘PtrSafekeyword’ few days ago. However not able to find my post hence posting as new thread. I have below line of code in my macro and am required to update it with ‘PtrSafe keyword’ Private Declare Function GetPrivateProfileStringLib "kernel32"...
  19. M

    Formula.Firewall Issue

    I have an Excel file that uses Power Query to get data from two Access tables. The query is executed via the following VBA code in the Workbook_Open codeActiveWorkbook.Connections("Query - SourceFileName").Refresh ActiveWorkbook.Connections("Query - GoodsOut").Refresh The SourceFileName query...
  20. S

    Power Query - insert column by repeating single value from another query

    Hi, I have a power query qryTotalSales that simply has SalesAgentID and SalesVolume as an aggregate SalesAgentID SalesVolume 1 27 2 4 3 72 4 11 In another power query qryThreshold I have restricted...

Some videos you may like

This Week's Hot Topics

Top