View to show corresponding fields from @Explode result

(I apologize if this looks messy…by ‘Preview’ button is kicking me out of the document).

I have a table that for simplicity sake let’s say is 2 rows and 2 columns (in actuality more like 5 x 4). The first colum has radio button field with a picklist of 10 choices. You select “A” from the list and then put a dollar amount in the second column. Here are two sample documents:

Document 1

A $100

B $200

Document 2

B $11

C $22

My problem is, how do I display this in a view? I have the first column categorized using @Explode so I get A, B and C on individual lines. But how do I say for column two I want only the corresponding dollar amount for the category? I tried using the programmatic name, but apparently that isn’t the individual end-result category name, but the full field content ‘unexploded’.

TIA

Subject: View to show corresponding fields from @Explode result

When I was trying to something similar I was directed to this page. Hopefully it will help you.

Subject: THX! View to show corresponding fields from @Explode result

This did help! Thanks! It showed a couple ways to handle multiple multi value fields in a view.