DIH Problem: create multiple docs from a single entity

[Lee Carroll]

Hi

I've 2 tables with the following data

table 1
id treatment_list
1 a,b
2 b,c

table 2
treatment id, name
a                  name1
b                  name 2
c                  name 3

Using DIH can you create an index of the form

id-treatment-id name
1a                  name1
1b                  name2
2b                  name2
2c                  name3

In short can I splt the comma separated field and process each as an
entity. From the docs and the wiki I can't see anything obvious.

I feel I'm missing something easier here. (Note its not my data so can't do
anything with the dodgy csv field )