+ Reply to Thread
Results 1 to 5 of 5

Power Query Value.ReplaceType and Value.Type

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    777

    Power Query Value.ReplaceType and Value.Type

    Hi,
    Can someone help with how this works, direct or refer to a blog , post etc.

    Please Login or Register  to view this content.
    This takes the source step with incorrrect data types and repalces with the correct form 'datatypes', but if I just use

    Please Login or Register  to view this content.
    on it's own it returns 'table' which is what it is, so what is happening when wrapped in Value.ReplaceType,
    the documentation does not really help,
    i have attaced the abaove example

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,997

    Re: Power Query Value.ReplaceType and Value.Type

    Value.Type(datatypes) returns a table type, which has a row-type, which is the specification of the column names and types in that table.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    777

    Re: Power Query Value.ReplaceType and Value.Type

    Thanks, i have not been able to dig up much re this function, still not sure I understand, but will stick with it.

    Richard.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,997

    Re: Power Query Value.ReplaceType and Value.Type


  5. #5
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    777

    Re: Power Query Value.ReplaceType and Value.Type

    Thanks,
    RD

+ 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. Power Query type of relatoin
    By zezo2021 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 01-10-2024, 03:52 PM
  2. Power query add data type
    By Dicken in forum Office 365
    Replies: 2
    Last Post: 03-27-2023, 08:06 AM
  3. Power query adding date type to code
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 03-17-2023, 03:59 PM
  4. Power Query apply data type to list
    By Dicken in forum Office 365
    Replies: 2
    Last Post: 10-27-2022, 07:16 AM
  5. Power Query Data Type Information
    By onedevilsstreet in forum Excel General
    Replies: 2
    Last Post: 09-28-2021, 06:48 AM
  6. Power Query: Change All --> Type and Uppercase
    By learning new things in forum Excel General
    Replies: 10
    Last Post: 11-29-2018, 05:40 PM
  7. Power Query Import Binary Data Type
    By brent_milne in forum Excel General
    Replies: 0
    Last Post: 08-13-2015, 09:46 AM

Tags for this Thread

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