Excel Add-In for Couchbase

Build 24.0.9060

PeriodsSeparator

The character or characters used to denote hierarchy.

Data Type

string

Default Value

"."

Remarks

When flattening objects and arrays, the add-in will use this value to separate different levels of objects and arrays. For example, if your Couchbase server returns a document like this (and FlattenObjects is enabled), then the add-in will return the columns "geo.latitude" and "geo.longitude" if the periods separator is set to ".".

{
  "geo": {
    "latitude": 35.9132,
    "longitude": -79.0558
  }
}

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060