• Multivalue fields - getting all values in Excel

    By Jim Barton 1 decade ago

    I have tested a simple export. The source contains multivalue fields. Only the first item from the field is exported to Excel. Is there a way to export all items from a multivalue field?

    • Multi-value fields

      By David Jeyachandran 1 decade ago

      Hi Jim,



      The simplest way to deal with multi-values is to use a formula. Please try using the formula

      @Implode( FieldName; ",")



      I've just tested this & it works. You can enter the formula in the "Export Fields" section that below the area where you select the fields. Let me know how this goes.



      You will also need to use a formula like @Abstract if you are dealing with a Rich Text field.



      Regards

      David