Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two questions. In the attached file, I loaded URLs using IN LINE. On the resulting straight table, when clicking the URL I am getting a Failed to Launch error message. Any idea how to fix?
In the same file, I also loaded URL's using a file instead of IN LINE. I am wondering how can I modify the script so that the values on the field, URL_,2 will be in the proper format ..... 'Link<URL>URL'? I can do this manually IN LINE but what if I am not loading IN LINE such as the case here?
Try adding another field like Name
In your excel sheet add below Name
ID | URL_2 | Name |
ABC | https://www.google.com | |
DEF | https://www.yahoo.com | Yahoo |
LOAD ID,
URL_2,
Name
FROM
[..\..\Book1_url.xlsx]
(ooxml, embedded labels, table is Sheet1);
Then in your straight table expr
Dim: ID
Expr: = Name & '<URL>' & URL_2
Try adding another field like Name
In your excel sheet add below Name
ID | URL_2 | Name |
ABC | https://www.google.com | |
DEF | https://www.yahoo.com | Yahoo |
LOAD ID,
URL_2,
Name
FROM
[..\..\Book1_url.xlsx]
(ooxml, embedded labels, table is Sheet1);
Then in your straight table expr
Dim: ID
Expr: = Name & '<URL>' & URL_2
Hi, hmm this didn't work.
Can you share that app where you added Name URL link that is not working.? It worked for me.
hello
don't forget to select link in expressions/display options/ representation
Let me know if I did something wrong?
You are using the wrong field in the expression tab use below
=NAME&'<URL>'&URL_2
Hi Mark:
I think that this thread could help you:
URL in Straight Table not Working
Best Regards,
Juan P. Barroso
Wow don't know how I missed that. Thanks!
Did it not solve your issue? If yes can you close the thread marking correct/helpful responses accordingly.