Power Query, What Am I missing here.
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Power Query, What Am I missing here.

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Power Query, What Am I missing here.

    Expression.Error: We cannot apply field access to the type List.
    Details:
    Value=List
    Key=PO Number
    Last edited by Fluff; Jul 9th, 2019 at 09:19 AM. Reason: Removed failed image attempt

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,566
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query, What Am I missing here.

    Quote Originally Posted by rp2019 View Post
    Expression.Error: We cannot apply field access to the type List.
    Details:
    Value=List
    Key=PO Number

    https://www.mrexcel.com/forum/image/...tsAwWTM2MYknne OLN7dXy3t z/N099NANwaYf8QA34 qRfSDRncDTz9PP79 nu7Zs7a2dvX73/8 PvGJT4D6E/OfthuPse7FvCEi6k6sn7uD5MOHR4ftHPWKnyws49fsayIiIiIiIqK wB7hXUzybTO8PG83/xcXF 0r4MMf/jCuv/56O0e9aqePMWofyz8RUXfiubM7bGU NPYIn3z8P CRx/9nOwc89od/ov 97p//c/z xOfwr377t/D//Zf/glf/92/gP/3t3 O6667D4T/8NP6HWz sl6ONk57czfDyUtbTViD83nvv4ezZs/jJT36i59PpNA4ePKhf07Uj fbAAw/Yuc688MILHVe0X/jCF/zG7z/ 4z/i85//vG4QU ...
    I don't know this kind of code, it's any new language?
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query, What Am I missing here.

    I am new here, I copy pasted an image and it came that way.

    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"IDoc number", Int64.Type}, {"Counter", Int64.Type}, {"Segment No.", Int64.Type}, {"SAP segment name", type text}, {"No. higher segment", Int64.Type}, {"Hierarchy level", Int64.Type}, {"Data Filter Value fo", type any}, {"Length", Int64.Type}, {"Application data", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Data Filter Value fo", "Hierarchy level", "No. higher segment", "Counter"}),
    AddedIndex = Table.AddIndexColumn(#"Removed Columns", "Index", 0, 1),
    #"Added Custom1" = Table.AddColumn(AddedIndex, "PO Number", each if [#"Segment No."] = 1 then
    Text.Trim (Text.Start([Application data],35))
    else {[Index]-1}[#"PO Number"])
    in
    #"Added Custom1"

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,566
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query, What Am I missing here.

    your code should be between [CODE]...[/CODE] tags like

    Code:
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"IDoc number", Int64.Type}, {"Counter", Int64.Type}, {"Segment No.", Int64.Type}, {"SAP segment name", type text}, {"No. higher segment", Int64.Type}, {"Hierarchy level", Int64.Type}, {"Data Filter Value fo", type any}, {"Length", Int64.Type}, {"Application data", type text}}),
        #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Data Filter Value fo", "Hierarchy level", "No. higher segment", "Counter"}), AddedIndex = Table.AddIndexColumn(#"Removed Columns", "Index", 0, 1),
        #"Added Custom1" = Table.AddColumn(AddedIndex, "PO Number", each if [#"Segment No."] = 1 then Text.Trim (Text.Start([Application data],35)) else {[Index]-1}[#"PO Number"])
    in
        #"Added Custom1"
    and post example [edit]of source[/edit] data associated with this code
    Last edited by sandy666; Jul 9th, 2019 at 09:30 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  5. #5
    New Member
    Join Date
    Jul 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query, What Am I missing here.

    Quote Originally Posted by sandy666 View Post
    your code should be between [CODE]...[/CODE] tags like

    Code:
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"IDoc number", Int64.Type}, {"Counter", Int64.Type}, {"Segment No.", Int64.Type}, {"SAP segment name", type text}, {"No. higher segment", Int64.Type}, {"Hierarchy level", Int64.Type}, {"Data Filter Value fo", type any}, {"Length", Int64.Type}, {"Application data", type text}}),
        #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Data Filter Value fo", "Hierarchy level", "No. higher segment", "Counter"}), AddedIndex = Table.AddIndexColumn(#"Removed Columns", "Index", 0, 1),
        #"Added Custom1" = Table.AddColumn(AddedIndex, "PO Number", each if [#"Segment No."] = 1 then Text.Trim (Text.Start([Application data],35)) else {[Index]-1}[#"PO Number"])
    in
        #"Added Custom1"
    and post example data associated with this code

    Segment No. SAP segment name Length Application data Index PO Number
    1 E1EDK09 1000 A11517 20190625190625 B -1 A11517
    2 E1EDKA1 1000 LF FTL MFG 0
    3 E1EDKA1 1000 YSCBW 7 1
    4 E1EDK11 1000 YHT1 1 Customer Horizon Start Date: 06/25/19 Customer Horizon End Date: 12/22/19 2
    5 E1EDK11 1000 YHT1 2 TMP 92 = 001 3
    6 E1EDP10 1000 BW K151860 001 0.000000 20190624 20190625 0.000000 03 534 4
    7 E1EDP16 1000 4W20190809 20190809 6 5
    1 E1EDK09 1000 A11517 20190625190625 B 6 A11517

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,381
    Post Thanks / Like
    Mentioned
    440 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Power Query, What Am I missing here.

    @rp2019
    Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
    Please be patient and do not attempt to post the question again.
    Also do not make spurious posts on other threads.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  7. #7
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,566
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query, What Am I missing here.

    Quote Originally Posted by rp2019 View Post
    .
    your source data has 9 columns but I see 6 only
    Last edited by sandy666; Jul 9th, 2019 at 09:53 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  8. #8
    New Member
    Join Date
    Jul 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query, What Am I missing here.

    well, I have removed some columns in my steps

  9. #9
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,566
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Power Query, What Am I missing here.

    Quote Originally Posted by rp2019 View Post
    well, I have removed some columns in my steps
    so post example of source data
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  10. #10
    New Member
    Join Date
    Jul 2019
    Posts
    11
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power Query, What Am I missing here.

    number Counter Segment No. SAP segment name No. higher segment Hierarchy level Data Filter Value fo Length Application data
    313708998 0 1 E1EDK09 0 1 1000 A11517 20190625190625 B
    313708998 0 2 E1EDKA1 1 2 1000 LF FTL MFG
    313708998 0 3 E1EDKA1 1 2 1000 YSCBW 7
    313708998 0 4 E1EDK11 1 2 1000 YHT1 1 Customer Horizon Start Date: 06/25/19 Customer Horizon End Date: 12/22/19
    313708998 0 5 E1EDK11 1 2 1000 YHT1 2 TMP 92 = 001
    313708998 0 6 E1EDP10 1 2 1000 BW K151860 001 0.000000 20190624 20190625 0.000000 03 534
    313708998 0 7 E1EDP16 6 3 1000 4W20190809 20190809 6
    313709018 0 1 E1EDK09 0 1 1000 A11517 20190625190625 B
    313709018 0 2 E1EDKA1 1 2 1000 LF FTL MFG

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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