List.Accumulate returning wrong value

[monojchakrab]

Hiya all,

I am working with a table as below :

The task is as follows :

1. Extract the month name using List.Accumulate as below :

 Table.AddColumn(ExtractAccountName, "Month Name", each List.Accumulate(MonthNames,
"",
(state,current) =>
if Text.Contains([Name],current,Comparer.OrdinalIgnoreCase) then 
state & "" & current else state))

The {MonthNames} is a list prepared separately and fed here. The result I am getting is a bit of an oddball : the column [MonthName] has an entry "FebMar" and only for one row; but "Mar" is not there in the text in any of the rows.

Is there something I am overlooking here? the Column {Account] is inserted in exactly the same way, without any strange results.

Any help appreciated.

[wdx223_Daniel · Accepted solution]

in 4th row, right there is a "mar" in Jiomart

[monojchakrab]

whoops did not realise that @wdx223_Daniel . Is there a workaround not to pick up the "mar" from the name of the account string.

would splitting the column using the delimiter "-" work better in this case?

[wdx223_Daniel]

Table.AddColumn(ExtractAccountName, "Month Name", each List.Select(MonthNames,each
Text.Contains([Name],"_"&_,Comparer.OrdinalIgnoreCase){0}?)

[monojchakrab]

@wdx223_Daniel - It adds column with lists as it should, but the list is populated with errors on every row. Am I getting something wrong?

[monojchakrab]

@wdx223_Daniel 

This is the error message :

[wdx223_Daniel]

Table.AddColumn(ExtractAccountName, "Month Name", each List.Select(MonthNames,(x)=>
Text.Contains([Name],"_"&x,Comparer.OrdinalIgnoreCase){0}?)

[monojchakrab]

@wdx223_Daniel :

Now the error message is as below :

Because probably the "text.contains", in this case will return a true, right?

Thanks for being in my corner. really appreciate.

[wdx223_Daniel · Accepted solution]

Table.AddColumn(ExtractAccountName, "Month Name", each List.Select(MonthNames,(x)=>
Text.Contains([Name],"_"&x,Comparer.OrdinalIgnoreCase)){0}?)

sorry for my carelessness.

[monojchakrab]

That worked !! @wdx223_Daniel . Thanks a ton.

[wdx223_Daniel · Accepted solution]

in 4th row, right there is a "mar" in Jiomart