Power Query, What Am I missing here.

rp2019

New Member
Joined
Jul 9, 2019
Messages
11
Expression.Error: We cannot apply field access to the type List.
Details:
Value=List
Key=PO Number
 
Last edited by a moderator:

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Expression.Error: We cannot apply field access to the type List.
Details:
Value=List
Key=PO Number

https://www.mrexcel.com/forum/image...rEAa56yJVLR0ssXiGKizPZbIGcWOI3JtsAwWTM2MYknne 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?
 
Upvote 0
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"
 
Upvote 0
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:
Upvote 0
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 nameLengthApplication dataIndexPO Number
1E1EDK091000A11517 20190625190625 B-1A11517
2E1EDKA11000LF FTL MFG0
3E1EDKA11000YSCBW 71
4E1EDK111000YHT1 1 Customer Horizon Start Date: 06/25/19 Customer Horizon End Date: 12/22/192
5E1EDK111000YHT1 2 TMP 92 = 0013
6E1EDP101000BW K151860 001 0.000000 20190624 20190625 0.000000 03 5344
7E1EDP1610004W20190809 20190809 65
1E1EDK091000A11517 20190625190625 B6A11517
<colgroup><col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="150" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5485;"> <col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;"> <col width="568" style="width: 426pt; mso-width-source: userset; mso-width-alt: 20772;"> <col width="59" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2157;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <tbody> </tbody>
 
Upvote 0
@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.
 
Upvote 0
numberCounterSegment No.SAP segment nameNo. higher segmentHierarchy levelData Filter Value foLengthApplication data
31370899801E1EDK09011000A11517 20190625190625 B
31370899802E1EDKA1121000LF FTL MFG
31370899803E1EDKA1121000YSCBW 7
31370899804E1EDK11121000YHT1 1 Customer Horizon Start Date: 06/25/19 Customer Horizon End Date: 12/22/19
31370899805E1EDK11121000YHT1 2 TMP 92 = 001
31370899806E1EDP10121000BW K151860 001 0.000000 20190624 20190625 0.000000 03 534
31370899807E1EDP166310004W20190809 20190809 6
31370901801E1EDK09011000A11517 20190625190625 B
31370901802E1EDKA1121000LF FTL MFG
<colgroup><col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <col width="134" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4900;"> <col width="64" style="width: 48pt;" span="7"> <tbody> </tbody>
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,938
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top