Array column view in Pipeline and Workshop

Ask the Community
, ,
1

Hi, in pipeline I have an array column that describes some module and their associated actions and it looks like this:
[module 1: action 1
module 2: action 2
module 3: action 3
module 4: action 4
]

But when i use this column in the workshop it looks very messy like this:
module 1: action 1|module 2: action2|module 3: action 3|module 4: action 4

How can I have a smart view like this in the workshop:

  • module 1: action 1

  • module 2: action 2

  • module 3: action 3

  • module 4: action 4

so one line then space then another line to look good followed by a bullet sign.

2

How are you accessing the data in Workshop?

My guess is as a property/properties on an Object type.

If you want to format this differently, you can either use some of the other widgets – did Object Table not work for you?

If they do not work, you can create a function to do this. In that case, you have a couple of different choices:

You can create a function that can be used in an Object Table, returning the value of two columns in a function backed column.

But since you mentioned the bullet formatting, that could also be done by a function that writes it’s output to a Markdown widget in Workshop.

Let me know more about your use case, and we can get closer to a good solution.

3

How are you accessing the data in Workshop?
Yes, Ontology Object

If you want to format this differently, you can either use some of the other widgets – did Object Table not work for you?
Yes, Object Table will work but it will be in table, but as I have many module and actions to show in single row, it may not feasible.

I believe function can be a good choice. I we use function then do I need to create it in code repo?

4

OK, you should create a function that does the following

  1. Pulls in the data pairs you want – you could store these in as key:value (module:action) in a Map or something similar.

  2. Outputs these to a string and formats them accordingly, e.g. for each key, output “- {key}: {value}” followed by a new line.

  3. This function can then be the input of a Markdown widget in Workshop.

Let me know how it works out!

5

There’s growing support for struct columns in the Ontology and Workshop. If your array columns are all key:value pairs, a struct column type might offer simpler implementation for the proposed function and other uses around the platform.