+ Reply to Thread
Results 1 to 4 of 4

Power Query Transform Column Names, condition , multiple

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

    Power Query Transform Column Names, condition , multiple

    Hi,

    i have been able to transform column names using a record like so create a record of column and function ;

    Please Login or Register  to view this content.
    then use that ;

    Please Login or Register  to view this content.
    so this seem quit similar to a list of { name, function }

    so I tried just one;

    Please Login or Register  to view this content.


    but is cannot get this construction to work on a nested list of column names and functions; i'd thought that ;

    Please Login or Register  to view this content.
    flist = nested col , func list.

    I can sort of see what the problem is in it is returning a list, but have not come up with a way around it, I have tried, function.invoke,
    which did not help, any suggestions on how to get this to work? I have attached the above/

    Richard.
    Attached Files Attached Files
    Last edited by Dicken; 07-04-2025 at 03:01 PM.

  2. #2
    Registered User
    Join Date
    05-05-2024
    Location
    Moscow, Russia
    MS-Off Ver
    365
    Posts
    31

    Re: Power Query Transform Column Names, condition , multiple

    Please Login or Register  to view this content.

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

    Re: Power Query Transform Column Names, condition , multiple

    to answer my own question, the closest I have got is this , starting point;


    Please Login or Register  to view this content.

    and this is a bit trial and error and not perfect, but this is what I have,

    Please Login or Register  to view this content.
    any further (useful ) suggestions welcome.

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

    Re: Power Query Transform Column Names, condition , multiple

    Well that is certainly a bit simpler, I'm going to have to take it apart as far as the skip part , just trying to visualize in my head.

+ 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. [SOLVED] Power Query , Transform Column of Records
    By Dicken in forum Office 365
    Replies: 4
    Last Post: 11-18-2024, 12:44 PM
  2. Replies: 2
    Last Post: 10-17-2023, 08:58 AM
  3. [SOLVED] Power Query, Transform Column by values in another columns
    By Dicken in forum Office 365
    Replies: 2
    Last Post: 06-30-2023, 09:10 AM
  4. [SOLVED] Power Query Transform multiple columns
    By Dicken in forum Office 365
    Replies: 2
    Last Post: 05-27-2023, 11:11 AM
  5. Power Query Multiply column in transform
    By Dicken in forum Office 365
    Replies: 1
    Last Post: 04-11-2023, 10:00 AM
  6. Power query - transform help
    By N3CREN in forum Excel General
    Replies: 0
    Last Post: 10-23-2020, 09:01 AM
  7. Power Query (Get & Transform) on Mac
    By SHI.NL in forum Excel General
    Replies: 2
    Last Post: 05-18-2018, 09:24 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