Keep format of native text field

wgechter

Hello, my native postgres db has a text column that is formatted in html.  I'm using Workbench to pull the text field out as a string but the formatting disappears when placed in Domo.  Is it possible to keep formatting when seen in Domo?  Thanks, Wendi

swagner

@wgechter you could handle in Workbench via the "Schema" section of the dataset job, or you can address in Domo via MagicETL.  Take a look in the "Edit Columns" section, and the "Set Column Type".

wgechter

Hmmm, I'm not asking about data types.  I'm wanting to see the same format as the text column in postgres, in Domo.  For example the data is in html tags and indented correctly.  I'd like it to keep the indentation as seen below:

<responseTransformer version="3.4.2">
     <inboundDataType>HL7V2</inboundDataType>
     <outboundDataType>HL7V2</outboundDataType>
<inboundProperties class="com.mirth.connect.plugins.datatypes.hl7v2.HL7v2DataTypeProperties" version="3.4.2">
<serializationProperties class="com.mirth.connect.plugins.datatypes.hl7v2.HL7v2SerializationProperties" version="3.4.2">
     <handleRepetitions>true</handleRepetitions>
     <handleSubcomponents>true</handleSubcomponents>
     <useStrictParser>false</useStrictParser>
     <useStrictValidation>false</useStrictValidation>
     <stripNamespaces>true</stripNamespaces>
     <segmentDelimiter>\r</segmentDelimiter>
     <convertLineBreaks>true</convertLineBreaks>