I have a process with variable inputs and I need the ability to check if a collection has a nested collection within it.
e.g. Input 1 - Collection, Headers and data
I need to find out Contents is a collection (so it can be deleted).
Ideally something like. Does [Collection 1] have any Field Types "Collection" within it.
Output - Header Name "Contents"
Each time the collection fields could have different headers - so I can't just look for the word "Contents" or a specific column number.
Also Collections might not always have a nested collection within it, so the solution needs to have a decision to follow the route to delete or not delete a column.
e.g. Input 2 - Collection, Headers and data
e.g. Input 1 - Collection, Headers and data
| Field | Value |
| Name (Text) | Mary |
| Number (Number) | 1 |
| Contents (Collection) | Row 1 of 2 |
I need to find out Contents is a collection (so it can be deleted).
Ideally something like. Does [Collection 1] have any Field Types "Collection" within it.
Output - Header Name "Contents"
Each time the collection fields could have different headers - so I can't just look for the word "Contents" or a specific column number.
Also Collections might not always have a nested collection within it, so the solution needs to have a decision to follow the route to delete or not delete a column.
e.g. Input 2 - Collection, Headers and data
| Field | Value |
| Name (Text) | Mary |
| Number (Number) | 1 |
| Info (Text | Hello |
| Contents (Text) | Red |