Use this function to add a new column by formulating URLs with an existing column.
Procedure
From a column menu, click
Edit column > Add column by fetching URLs.
In the
New column name field, enter a name for the new column.
In the
Throttle delay field, enter a time (in millisecond).
In the
Expression field, enter the expression to formulate the URLs for generating the new column values.
TIBCO Clarity can fetch JSON files from any web services based on values in a column and create a new column out of it. When you have the JSON information, you can use the
parseJson() function to create new columns, transform cell values, or even create new facets for further analysis. For example, if you are interested in the
link element of a JSON result returned by fetching URLs from the existing column, use the following expression:
value.parseJson()["link"].
Select from the following options to handle errors in a cell:
