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 ...
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"
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 |
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 |