AnsweredAssumed Answered

Numbered list of multiple records to one field

Question asked by matus.cechvala@gmail.com on Jan 4, 2012
Latest reply on Jan 18, 2012 by philmodjunk

Title

Numbered list of multiple records to one field

Post

Hello,
I need to join multiple records and fields to one field. Can anybody help me with this task?

I have this content:

MainPos SubPos Publish Name Price OUT
1 0  Y  Aaaaaaaa  25,00  
1 1  Y  Bbbbbbb  15,00  
1 2  N  Cccccccc  10,00  
1 3  Y  Dddddddd  5,00  
2 0  Y  Eeeeee  10,00  
2 1  N  Fffffff  15,00  
2 2  Y  Gggggggg 5,00   


And I need to have in records with SubPos = 0 in field “OUT” the numbered list of Name & Price, sorted by Price, if "Publish" value is Y:

For record 1|0 it means OUT field contains:
1. Dddddddd 5,00
2. Bbbbbbb 15,00
3. Aaaaaaaa 25,00

For record 2|0 it means OUT field contains:
1. Gggggggg 5,00
2. Eeeeee10,00

(other OUT fields are not important, they could stay empty)

Outcomes