Parent Child Relationship Field / Tree Structure Field

Anonymous — Fri, 06 May 2016 09:47:29 GMT

Hi guys

Has anyone worked with Parent/Child Structures like this
I want to remove Level 1-6 and have them in different fields for
selection for example on Level 2 (COOKE).

The delimiter is ‘ - ’

RANDFONTEIN-COOKE - COOKE - CONTROLLED NON SHAFT AREA - COOKE 3
- COOKE 3 OCCUPATIONAL HEALTH (CIRTECH ALARM) - COOKE 3 OCCUPATIONAL HEALTH
(CIRTECH ALARM)

Your assistance will be appreciated.

Re: Parent Child Relationship Field / Tree Structure Field

swuehl — Fri, 06 May 2016 15:25:08 GMT

What is your expected result?

You can split a single field into multiple fields using subfield:

LOAD

Subfield(FIELD,'-',1) as Part1,

Subfield(FIELD,'-',2) as Part2,

Subfield(FIELD,'-',3) as Part3,

Subfield(FIELD,'-',4) as Part4,

Subfield(FIELD,'-',5) as Part5

FROM ...;

topic Parent Child Relationship Field / Tree Structure Field in QlikView

Parent Child Relationship Field / Tree Structure Field

Re: Parent Child Relationship Field / Tree Structure Field