Forum Discussion

Shaiksamar2244's avatar
Shaiksamar2244
Frequent Visitor
2 years ago
Solved

Row by Row condition

Hello Everyone,

 

Could someone please assist me with this?

 

ERP system is not picking up created from for all requests. I have given the output I'm looking for.

 

The created form should be filled based on the document numbers.

 

Document NumberCreated FromAmount Document NumberCreated FromAmount
RMAASI002746 24150 RMAASI002746Sales Order SOASI01601824150
RMAASI002746 33892 RMAASI002746Sales Order SOASI01601833892
RMAASI002746 202256 RMAASI002746Sales Order SOASI016018202256
RMAASI002746 1609959 RMAASI002746Sales Order SOASI0160181609959
RMAASI002746Sales Order SOASI016018447982 RMAASI002746Sales Order SOASI016018447982
RMAASI002746 14700 RMAASI002746Sales Order SOASI01601814700
RMAASI002746 36750 RMAASI002746Sales Order SOASI01601836750
RMAASI003053Sales Order SOASI0213251452 RMAASI003053Sales Order SOASI0213251452
RMAASI003053Sales Order SOASI0213252638 RMAASI003053Sales Order SOASI0213252638
RMAASI003053 48600 RMAASI003053Sales Order #SOASI02132548600
RMAASI003053 1609959 RMAASI003053Sales Order SOASI0213251609959
RMANUS000248 123684 RMANUS000248 123684
RMAASI003189Sales Order SOASI0227972100 RMAASI003189Sales Order SOASI0227972100
RMAASI003189 13045 RMAASI003189Sales Order SOASI02279713045

 

Thanks,

Samar

Need Help
  • Shaiksamar2244's avatar
    Shaiksamar2244
    2 years ago

    Hi Stephane,

     

    I'm not sure why I'm getting this, Could you please help me on this?

     

     

4 Replies

  • slorin's avatar
    slorin
    Super User
    2 years ago

    Hi, 

    let
    Source = YourSource
    Group = Table.Group(Source, {"Document Number"}, 
         {{"Created From", each Text.Combine(List.Distinct([Created From]))}, 
          {"Amount", each [Amount]}}),
    Expand = Table.ExpandListColumn(Group, "Amount")
    in
    Expand

    Stéphane

  • Shaiksamar2244's avatar
    Shaiksamar2244
    Frequent Visitor
    2 years ago

    Hi Stephane,

     

    I'm not sure why I'm getting this, Could you please help me on this?