[CrystalRenee16]

I was wondering if there is a way to export the site categories for each product into a single line. Currently, I am only able to export the products with each category on its own line. This ends up giving me 2 to 10 lines for each product. I am hoping there is a way to have them populate as separate columns on one line, or even all into one column with a separator.

Is there a way to do this?
This is a cached copy. Click here to see the original post.

[markluu]

Hi CrystalRenee16,

Can you try the following:Create an Item Saved Search and in the Results,Field: NameSummary Type: Group

Field: Formula (Text)Summary Type: Maximum
Formula: NS_CONCAT({category})

What the search will give you is one row for each item, and it will separate each category into the 2nd column with a comma separator.

Let us know if this helps you.

Cheers

[CrystalRenee16]

Hi Markluu,

Yes, that worked perfectly. Thank you!

Crystal

[JCirocco]

Interesting. In the drop down of functions I didn’t see NS_Concat. Are there other functions not displayed that are available? Or a listing somewhere? I could have used that many times in the past.

[Author]

Posts