Results 1 to 5 of 5

Power Query , Transform Column of Records

Threaded View

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

    Power Query , Transform Column of Records

    Hi, I have been trying to transform a column of records by another column ; I have mangaged this as an 'addcolumn' so;

    Table.AddColumn(
      ToTable, 
      "Custom", 
      (x) =>
        List.Accumulate(
          Source[Name], 
          x[RecColumn], 
          (s, c) => Record.TransformFields(s, {c, (y) => Text.Contains(y, x[Item])})
        )
    )
    But I cannot figure how to get to the 'outside' columns when using Table.TransformColumns,

    List.Accumulate( Source [Name] , ToTable, (s,c)=> 
      Table.TransformColumns( s, { "A" , (x)=>   Record.TransformFields( x , 
                                                  { c,  (y)=> "Item col ? "  } ) }  ))
    I have attached a workbook showing working out so far, There is an addcolumn query using the above and a query called RecordTable
    which is where I've got to using transform column; so the question really is to access , in this case the 'item' column when using
    Table.TransformColuimns ?

    Richard.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-17-2023, 08:58 AM
  2. [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
  3. Power Query Multiply column in transform
    By Dicken in forum Office 365
    Replies: 1
    Last Post: 04-11-2023, 10:00 AM
  4. Replies: 6
    Last Post: 11-22-2021, 05:22 PM
  5. Power query - transform help
    By N3CREN in forum Excel General
    Replies: 0
    Last Post: 10-23-2020, 09:01 AM
  6. [SOLVED] Power Query transform help
    By ierosadopr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2019, 05:25 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