Row by Row condition

[Shaiksamar2244]

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 Number	Created From	Amount		Document Number	Created From	Amount
RMAASI002746		24150		RMAASI002746	Sales Order SOASI016018	24150
RMAASI002746		33892		RMAASI002746	Sales Order SOASI016018	33892
RMAASI002746		202256		RMAASI002746	Sales Order SOASI016018	202256
RMAASI002746		1609959		RMAASI002746	Sales Order SOASI016018	1609959
RMAASI002746	Sales Order SOASI016018	447982		RMAASI002746	Sales Order SOASI016018	447982
RMAASI002746		14700		RMAASI002746	Sales Order SOASI016018	14700
RMAASI002746		36750		RMAASI002746	Sales Order SOASI016018	36750
RMAASI003053	Sales Order SOASI021325	1452		RMAASI003053	Sales Order SOASI021325	1452
RMAASI003053	Sales Order SOASI021325	2638		RMAASI003053	Sales Order SOASI021325	2638
RMAASI003053		48600		RMAASI003053	Sales Order #SOASI021325	48600
RMAASI003053		1609959		RMAASI003053	Sales Order SOASI021325	1609959
RMANUS000248		123684		RMANUS000248		123684
RMAASI003189	Sales Order SOASI022797	2100		RMAASI003189	Sales Order SOASI022797	2100
RMAASI003189		13045		RMAASI003189	Sales Order SOASI022797	13045

Thanks,

Samar

[Shaiksamar2244]

Hi Stephane,

Thank you so much issue is sorted.

Thanks,

Samar

[slorin]

Row 6 : Table.Group(#"Changed Type", ...

[Shaiksamar2244 · Accepted solution]

Hi Stephane,

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

[slorin]

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