Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

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

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


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

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

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


talk is cheap, supply exceeds demand
Not applicable

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

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