Use of reference table with comma-separated-values in one field

[#1]

Dear all,

I have the following issue: I read a reference table:

Referencetable

ECU	Car
MIL01	Cabrio2015,SUV2017,SUV2018
Huentry	Cabrio2015
HuentryPLUS	SUV2017
HUnextGen	SUV2018,Cabrio2021, Limo2018
LHZ02	Cabrio2015,Cabrio2021

And I have a list of Cartypes and Cars

CarList

Cartype	Car
Cabrio	Cabrio2015
Cabrio	Cabrio2021
SUV	SUV2017
SUV	SUB2018
Limo	Limo2018
…

When I now select (by clicking) in CarList a Cartype (e.g. "Cabrio") and want to get relevant ECUs for this cartype (in this case: MIL01, Huentry, HUnextGen, LHZ02).

Any idea how to do this?

Thanks

Oliver

[Gysbert_Wassenaar · Accepted solution]

I'd split the Car field in the script into separate records per car:

Referencetable:

LOAD

     ECU,

     SubField(Car,',') as Car

FROM

     ...source...

     ;

That's all that's necessary

[#3]

Hi Gysbert,

thanks a lot for your quick answer - that was easy, I only did not figure out what to search for in the manuals... Tried and works as I need. Thanks!!!

Oliver