multiple fields in one column

[#1]

Hi there, I am trying to build out a list of recommended items to buy based on their attributes into a straight table. I have two fields. Items, which the customer bought and substitute items, which the customer could buy instead of what he bought. I need to have the two different fields populate in one column in the straight table. Is this possible? Thanks for the help!

[Jason_Michaelides]

Can you supply some source data and how you want it to look?

[#3]

Not sure if I address your problem here,

I had a request to join values from 2 fields values together and output to 1 column.

I used:

      Concat( [Field1] & '-' & [Field2], ',', [Field1])

This will return a joined string of all values as "field1-field2" pairs seperated by commas from the same group and sorted by field1.

[#4]

Hi, thanks for the responses. What I have is, bought_item field. Lets say there are 3 items, 1,2,3. I have substitute_item, 4, that should be bought instead of bought_item 1. So, in my column I want to see recommended items to buy as items 2,3,4.

[Jason_Michaelides]

Please supply a sample qvw so we can help you further. It is not clear from your posts what you are working with.

Thanks,

Jason