CONCAT function

CONCAT

The Klipfolio CONCAT function joins two or more values into one text string.

The syntax for the CONCAT function is:

CONCAT (data )

Parameter

data the values to join vector

How to use the CONCAT function

The CONCAT function is used to create a comma separated list of values. The CONCAT function is commonly used to prepare data for use in a spark line, spark bar, or win/loss, although it is useful in a number of other scenarios. By concatenating values into a string, the CONCAT function is able to create a custom series of values.

To use the CONCAT function

Note: These procedures assume you are in the Klip Editor as a result of building a Klip or editing a Klip.

  1. Select a component from the Component Tree (Column, Primary Value, etc).
  2. Click the Start Formula link in the formula editor.
  3. Click the Insert Function button on the formula editing toolbar.
  4. Select Text>CONCAT from the Function's menu.

  1. Click the data link in the CONCAT function.
  2. Select a value or range of values from the data source.
Note: This will be the first set of values used in your Klip.
  1. Click the data link in the CONCAT function.
  2. Click the Insert literal string or number button on the formula editing toolbar.
  3. Type a comma , in the text field.
  4. Click the Apply button.
  5. Click the data link in the CONCAT function.
  6. Select a value or range of values from the data source.
  7. Repeat steps 5-12 until the values you want are displayed in the Klip.

Tip! Use the SLICE function to prepare the data for use in a Klip. 

The values are formatted as a comma separated list. 


To format a comma separated list as a mini chart 

Note: These procedures assume you have completed the steps above.

  1. Open the Properties tab.
  2. Select one of the following options from the Format as menu: spark line, spark bar, win/loss chart.

Note: You can use any of the mini chart formats with a comma separate list. Choose a format that is appropriate for your data.

Your data is now formatted as a mini chart.


Examples of the CONCAT function

The CONCAT function is a useful function because it allows you to create comma separated lists and strings of values. There are a number of ways that you can put this function to work, such as in a spark line, spark bar, or win/loss chart. The following examples show some of the different ways you can use the CONCAT function to build Klips.

Using the CONCAT function to display a series of images

The CONCAT function can be used to create a series of unique images in your Klip. This is one of the more interesting ways you can use this function, but requires a URL that can be disambiguated. For example, you could use a Google Maps image URL to represent locations from your data source. In this example, the Google Maps URL is broken into two parts with the data source providing the values for the map to reference. These steps provide a rough guide on how to use an image URL with a CONCAT function - the exact steps required will be determined the URL and format of your data. 

Tip! Check out the image URL article for more information.

  1. For the first data link, paste the following URL using the free text option: http://maps.googleapis.com/maps/api/staticmap?center=
  2. For the second data link, use a SLICE function to specify which city to show on a map.
  3. For the third data link, paste the following URL using the free text option: &zoom=11&size=400x400&sensor=false.


Using the CONCAT function to display a series of URLs

The CONCAT function can be used to create a series of unique URLs in your Klip. This requires disambiguating a URL and using values from your data source to provide part of the URL. In this example, the Wikipedia link is supplied at the beginning of the CONCAT function, with the city name being selected from the data source to point to the correct page.

Tip! Check out the hyperlink article for more information.


What's next?

Did you have trouble with the material in this article?

These articles may help:




Functions

  1. Introduction: Using formulas
  2. Data Manipulation functions
  3. Logic functions
  4. Math functions
  5. SELECT function
  6. Text Functions
  7. Date and Time Functions
  8. Statistics Functions
  9. ABS function
  10. AND function
  11. ARRAY function
  12. AVERAGE function
  13. BETWEEN function
  14. BLANK function
  15. CAPITALIZE function
  16. CEILING function
  17. CONCAT function
  18. CONTAINS function
  19. COUNT function
  20. COUNTALL function
  21. COUNTBLANK function
  22. COUNTDISTINCT function
  23. COUNTIF function
  24. COUNT_DAYS function
  25. COUNTNUMERIC function
  26. CUMULATIVE function
  27. CUMULATIVE_DIFFERENCE function
  28. DATASOURCE function
  29. DATE and DATEVALUE functions
  30. Using Date and Time Formats
  31. DATERANGE function
  32. DATE_ADD function
  33. DATE_CLOSEST function
  34. DATE_CONVERT function
  35. DATE_ENDOF function
  36. DATE_IN function
  37. DATE_SET function
  38. DATE_STARTOF function
  39. DATE_UNITVALUE function
  40. FLOOR function
  41. ERF function
  42. FIRST function
  43. ERFC function
  44. GROUP and GROUPBY functions
  45. IF function
  46. IN function
  47. INDEXOF function
  48. JOIN function
  49. LAST function
  50. LASTINDEXOF function
  51. LEFT function
  52. LOOKUP function
  53. LOWER function
  54. MAP function
  55. MAX function
  56. MIN function
  57. MEDIAN function
  58. MOD function
  59. MODE function
  60. Moving Average (Cumulative)
  61. Moving Average (Exponential)
  62. Moving Average (Simple)
  63. NORMSDIST function
  64. NOT function
  65. NOW function
  66. NUMBERFORMAT function
  67. OR function
  68. PADVALUES function
  69. POWER function
  70. RANK function
  71. REMOVE_EMOJI function
  72. REPEAT function
  73. REPLACE function
  74. REVERSE function
  75. RIGHT function
  76. ROUND function
  77. SET function
  78. SLICE function
  79. SLOPE function
  80. SORT function
  81. SPLICE function
  82. STANDARDIZE function
  83. STDEV function
  84. STDEVP function
  85. SUBSTITUTE function
  86. SUBSTITUTE_REGEX function
  87. SUBSTRING function
  88. SUM function
  89. SUMIF function
  90. SWITCH function
  91. TEXT_REVERSE function
  92. TODAY function
  93. TRIM function
  94. TRUNCATE function
  95. UPPER function
  96. URLDECODE function
  97. URLENCODE function
  98. VARIANCE function
  99. VARIANCEP function
  100. YESTERDAY function
  101. ZTEST function

Feedback and Knowledge Base