Dynamic URL

[Anonymous]

Hi All,

I have a situation where I have appended two tables and now want to create a column for Dynamic URL.

Below are the two URL column i created seperately for the tables.

url 1 = "https://dev.azure.com/powermatrix/Sparkplug%20R2/_workitems/edit/" & 'sparkplug'[Work Item Id]

url 2 = "https://dev.azure.com/powermatrix/Propeller%20R2/_workitems/edit/" & 'propeller'[Work Item Id]

Both the URLs were working fine seperately. 

Now I have appended the two tables and want a column with URL for both the cases.

Plz let me know the best approach I can follow for the same.

Regards,

Himanshu

[moizsherwani]

@Anonymous you say you have appended the two tables, but if you do so after the URL column is created then the url column should automatically be part of the appended table. 

If you have appended the raw tables and not created the url column, in that case you will need to either have a custom column in each table which identifies which of the two tables it is (sparkplug or propeller) or there might be a field in the existing tables which can you let you know which table the data is from.

Once this is done you can use something like

URL =
SWITCH (
    [Column which identifies which table the data is from],
    "SPARKPLUG",
        "https://dev.azure.com/powermatrix/Sparkplug%20R2/_workitems/edit/" & [Work Item Id],
    "PROPELLER" = "https://dev.azure.com/powermatrix/Propeller%20R2/_workitems/edit/" & [Work Item Id]
)

[Anonymous]

@moizsherwani 

I have a column "Product" in my Appended query (This is a calculated column) but when using Switch function it is not giving the desired result. Data is not coming correct.

I want something like :

When 

Combine[Product]="Sparkplug" then url will be 

"https://dev.azure.com/powermatrix/Sparkplug%20R2/_workitems/edit/" & [Work Item Id]

And when 

Combine[Product]="Propeller" then url will be 

"https://dev.azure.com/powermatrix/Propeller%20R2/_workitems/edit/" & [Work Item Id]

[moizsherwani]

@Anonymous  did you change the needed column names, does the following not work for you?

Calculated Column URL =
SWITCH (
    Combine[Product],
    "Sparkplug",
        "https://dev.azure.com/powermatrix/Sparkplug%20R2/_workitems/edit/" & Combine[Work Item Id],
    "Propeller", "https://dev.azure.com/powermatrix/Propeller%20R2/_workitems/edit/" & Combine[Work Item Id]
)

[moizsherwani · Accepted solution]

I made an error on the previous formula "Propeller" should be followed by a comma (,) and not an equal sign (=)

[Anonymous]

I actually changed the source column and it worked.

Thanks for the help !!!

Regards,

Himanshu