+ Reply to Thread
Results 1 to 2 of 2

Using parameters like equivalent in "Get & Transform"

  1. #1
    Registered User
    Join Date
    07-07-2008
    Location
    israel
    Posts
    6

    Using parameters like equivalent in "Get & Transform"

    Hi there,
    I was wondering how can I use a parameter in a query using the "Get & Transform" .
    For simplification purposes, I have a saved query called 'dbQuery':

    Please Login or Register  to view this content.
    IdPara is the parameter.
    "Get & transform" doesn't recognize this query because it has a parameter and I know I have to drop the parameter so that "Get & transform" will recognize it.
    But how do I use it to get the same result as if I were using the parameter?
    Thanks,

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Using parameters like equivalent in "Get & Transform"

    Post your Power Query (Get & Transform) code without the parameter, please; then I can adapt to accept the parameter.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel equivalent to Google Sheets' "importdata" function?
    By bgreeson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-25-2017, 11:46 PM
  2. Replies: 7
    Last Post: 01-03-2013, 04:13 PM
  3. [SOLVED] UDF to remove "equivalent" expressions from a ";" delimited string
    By dredwolf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2012, 07:25 PM
  4. can a "MINIF" formula be built, equivalent to "SUMIFS"?
    By jrtaylor in forum Excel General
    Replies: 4
    Last Post: 10-22-2011, 12:44 PM
  5. macro - transform a word e.g. "skyscraper" into numbers
    By excelmax in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2008, 04:27 PM
  6. "Reference is not Valid" when calling fast fourier transform
    By JacksonRJones in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2006, 09:10 AM
  7. [SOLVED] What would be Excel's equivalent for a Lotus line "[Input].MoveCellPointer $Right,1"?
    By Spamfighter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2005, 04:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1