Forum Discussion
Combining Columns
I searched through this community and found the following formula for a new column: Text.From([Column) & Text.From([Column2]) & Text.From([Column3]) I used it and it works great! However, if...
According to your initial information, I would expect that your code would look like:
= Table.AddColumn(#"Changed Type6", "PMSearchData", each Text.From([PMNUM])&" , "&Text.From([DESCRIPTION])&" , "&Text.From([JPNUM])&" , "&Text.From([USEFREQUENCY])&" , "&Text.From([FEQUNIT])&" , "&Text.From([ROUTE]))
Thanks! I've been looking at this so long that I missed the obvious! :-)
I corrected and now I get a different error. See attached.
Well, the message looks quite obvious: you are refering to a field [FEQUNIT} that doesn't exist.
Just verify and correct the field name.
Note: PowerQuery is case sensitive, e.g. "FEQUNIT" is not "FeqUnit".