Summary

This operation is used for splitting data columns.


E.g. Making three columns out of one column.

Example: Split one column into three columns

Situation

The content of column A Identifier should be separated into three different columns:

Settings

Result

Project-File

Confluence Op Split Columns.gzip

Want to learn more?

Settings

-

Columns of input table


AccessDeniedAccess DeniedJCYMXF2TB8SGX4X0Q2LBtjAenOnfPUbmqebvVb33APeu3ytAMprTCcdvmqfPSfroNCVFwixTtRlG/YWCb0KHlhDXqAE=

Parameter


AccessDeniedAccess DeniedJCYW7JDA391PX7B5aN/HlAyo3P21EQdxlQhJpySbceVocn0Z7WEzNzT1Y0ZhdNjNqQO6CmKZffnn0olM8CO5yW4y23Y=

Examples

Example 1: ...

...

Calculation method

Settings

Result

...

 

 

Troubleshooting

Problem

Frequent Cause

Solutions

...

 

...

Related topics

  • This operation is often used to separate data for searches, or for output data.
  • The opposite operation is Combine Columns (link to old wiki).