Search:

Type: Posts; User: rp2019; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    that works. thanks for that. But i want to understand what i was doing wrong. Are we using the index column at all in your code? And why do we trim the Application Data column. I need it for further...
  2. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    that is the data that we are getting from outside party and they have 35 characters allocated for it. Does that influence what I am trying to do?
  3. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    I already posted the source data
  4. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    IGNORE MY PREV MSG




    <colgroup><col width="64" style="width: 48pt;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="64" style="width: 48pt;"...
  5. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    <colgroup><col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="64" style="width: 48pt;" span="2"> <col width="124" style="width: 93pt; mso-width-source:...
  6. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    I am looking at the column "Segment_No". if it is 1 then, the PO_Number=Application_data field is trimmed 1-35 , else PO_Number = PO_Number from the previous record
  7. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    <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"...
  8. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    well, I have removed some columns in my steps
  9. Replies
    22
    Views
    1,963

    Re: Power Query, What Am I missing here.

    <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...
  10. Replies
    22
    Views
    1,963

    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...
  11. Replies
    22
    Views
    1,963

    Power Query, What Am I missing here.

    Expression.Error: We cannot apply field access to the type List.
    Details:
    Value=List
    Key=PO Number
Results 1 to 11 of 15