Forum Discussion

New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago

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...
Need Help
New2PowerBI's avatar
New2PowerBI
Helper III
9 years ago

Here is what error I get:

 

 

 Here is the updated one:

= Table.AddColumn(#"Changed Type6", "PMSearchData", each [PMNUM]&" , "&[DESCRIPTION]&"   ,   "&[JPNUM]&"   ,   "&[USEFREQUENCY]&"   ,   "&[FEQUNIT]&"   ,   "&[ROUTE])

 

I have no issues if I do just 3 items.  In this case, I added three more fields and I received the error.  Not sure if it has to do with numbers and/or null values now, maybe it's more tied to the number of columns I'm trying to pull in versus what is in the column?

 

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

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]))
  • New2PowerBI's avatar
    New2PowerBI
    Helper III
    9 years ago

    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. 

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      9 years ago

      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".