Forum Discussion

Matt0515's avatar
Matt0515
Frequent Visitor
6 years ago
Solved

Custom Column to Concatonate values where NOT BLANK

Hello Experts:

 

I am trying to create a custom column of URL links for only lines that are NOT BLANK in another column.

I know how to make the final output an active link, I am having issues creating the logic in Power Query to ignore the lines with blank in the ID Column.

So in summary, I want to add "https://my.salesforce.com/" & [ID Column]

Sorry if this issue is solved on the boards somewhere, I have been searching all day and cant seem to find what I am looking for:

 

Example:          ID Column:         Desired Result:

Line1                ABCDEF             https://my.salesforce.com/ABCDEF

Line2

Line3                HIJKLMN            https://my.salesforce.com/HIJKLMN

Line4

Line5                1234567             https://my.salesforce.com/1234567

 

Thank you in advance for the help!

 

Matt

 

 

Need Help

1 Reply

  • nandic's avatar
    nandic
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    Matt0515 ,
    In Power Query: Add new column > Custom Column:
    Concatenate URL = if [ID] is null then null else "https://my.salesforce.com/"&[ID]
    After that, save changes in Power Query and then set data category for this column to be Web url.