Help

[Syndicate_Admin]

= Table.AddColumn(#"Changed Type3", "Recode", each if Text.StartsWith([Change Type_ID],{"P","A","B","C"}) then [Change Type_ID] else [Location]&Text.End([ChangeType_ID],10))

This is not working in my query and Error for all

Error expression,  We cannot convert a value of type List to type Text.
Details:
Value=List
Type=Type

[Syndicate_Admin]

Thank you for your reply. It working.

[Vijay_A_Verma · Accepted solution]

Use this

= Table.AddColumn(#"Changed Type3", "Recode", each if List.Contains({"P","A","B","C"}, Text.Start([Change Type_ID],1)) then [Change Type_ID] else [Location]&Text.End([ChangeType_ID],10))