Urgent help require on Simple data hierarchy

[#1]

My tableis having three columns like Brand No, Brand Name and Mat Name.

I want to create a list box which will have Band(with '+' sign) and when i will click on that it will show all Mat name for that Brand

Bran No.	Brand	Mat Name
1	Al	Masy
1	Al	kite
2	BL	pen
2	BL	pencil
2	BL	kart
2	BL	mask
2	BL	chart
2	BL	cap
3	CL	toy
3	CL	game

[#2]

i want in list box with data hieracchy..

[rbecher]

Hi,

just add a concatenated field for the hierarchy (see attachment):

data:

LOAD *, Brand & '/' & MatName as Hierarchy;

LOAD * INLINE [

    BranNo, Brand, MatName

    1, Al, Masy

    1, Al, kite

    2, BL, pen

    2, BL, pencil

    2, BL, kart

    2, BL, mask

    2, BL, chart

    2, BL, cap

    3, CL, toy

    3, CL, game

];

- Ralf

[#4]

But in above example we are not able to select parent like AL, BL, We need to select data inside it?

Why is it so? Can we select Al, BL directly

[nirav_bhimani]

HI Kirti,

Please find the attchment which will help you to build hierarchy structure.

Regards,

Nirav Bhimani

[#6]

Hi Nirav,

Pl find attched application.

as per your example -In ths application parent is Short_Description and child is Material Type.

e.g.

Short_Description is grouped and when we press '+' sign it will show all corresponding Material Type

[nirav_bhimani]

HI Kirti,

Now whats the problem in creating a hierarcgy structure from it.

Remember in Hierarchy involve Parent code, Child code and Child name only.

Then make Transaction table which is having all the child data and which is map with your Hierarchy with Child Code.Hope this will help you.

Or else can you tell me what you want to do further. If possible then share your datafile so that I can help you further to build hierarchy structure.

Regards,

Nirav Bhimani

[#8]

i have already shared QVW.

[#9]

I have only 2 columns.i need data hierarchy. Pl Help

Short_Desc	Material_Name
Aerobid	(DISC)AEROBID-M PLACEBO DISPLAY EACH
Aerobid	AEROBID-M SAMPLE(1 CAN X 7GM)  7GM  DISC
Aerobid	DISC AERO BRONCTREE MODEL      EACH
Aerobid	DISC AEROBID-M INHALER SYSTEM     7GM
Aerobid	DISC AEROBID-M PA SAMPLE (1 CAN x 3.5GM)
Aerobid	DISC AEROBID-M SAMPLE(1 CAN X 3.5 GM)
Aerobid	DISC AEROBID-PA SAMPLE (1 CAN x 3.5GM)
Aerobid	DISC AEROBID INHALER SYSTEM     7GM
Aerobid	DISC AEROBID SAMPLE (1 CAN X 3.5 GM)
Aerobid	DISC AEROBID SAMPLE(1 CAN X 7GM)    7 GM
Aerobid	DISC AEROCH. DEMO CTR W/MOUTHPCE BX 20
Aerobid	DO NOT USE * AEROBID-M PLACEBO -> 2489
Aerobid	DO NOT USE * AEROBID PLACEBO CAN&HOLDER
Benicar	DISC Benicar 20/12.5mgHCT Sampl 7-bottle
Benicar	DISC Benicar 20mg Sample (10307) 1X7
Benicar	DISC Benicar 20mg Sample 7ct bottle each
Benicar	DISC Benicar 20mg/12.5mg HCT 30ct EEP ea
Benicar	DISC Benicar 40/12.5mgHCT Smpl 7-btl eac
Benicar	DISC Benicar 40/25mgHCT Sample 7ct bottl
Benicar	DISC Benicar 40mg Sample (#10407) 1X 7
Benicar	DISC Benicar 40mg Sample 7ct bottle each
Benicar	DISC Benicar 40mg/12.5mg HCT 30ct EEP ea
Benicar	DISC Benicar JNC7 Goal Program
Celexa	CELEXA                              1 OZ
Celexa	CELEXA 20MG                           90
Celexa	CELEXA 20MG                          500
Celexa	CELEXA 20MG                         1000
Celexa	CELEXA 20MG                         5000
Celexa	CELEXA 40MG                           90
Celexa	CELEXA 40MG                          500
Celexa	CELEXA 40MG                         1000
Celexa	CELEXA 40MG                         5000
Celexa	CELEXA BULK 10MG TABLETS TRADE
Celexa	CELEXA BULK 10MG TABLETS Validation
Celexa	CELEXA BULK 20MG TABLETS TRADE
Celexa	CELEXA BULK 40MG TABLETS TRADE
Celexa	CELEXA TABLETS 10MG     100
Celexa	CELEXA TABLETS 20MG     100
Celexa	CELEXA TABLETS 20MG(CHALLENGE) 30  DISC
Celexa	CELEXA TABLETS 40MG     100
Celexa	CITALOPRAM HBR
Celexa	DISC CELEXA-PA 20MG Sample 1X7    1 each
Celexa	DISC CELEXA-PA 20mg STRTR KIT 1x14 1cd
Celexa	DISC Celexa-PA Tablets 40mg     100
Celexa	DISC CELEXA     4 OZ
Celexa	DISC CELEXA  Liquid     8 OZ
Celexa	DISC CELEXA 20MG      30
Celexa	DISC CELEXA 20MG H.U.D.            10X10
Celexa	DISC CELEXA 20MG SAMPL(1X7 W/O GRAV)1CRD
Celexa	DISC CELEXA 20MG SAMPLE (1x7 TAB) 1 CARD
Celexa	DISC CELEXA 20MG STRTR KIT(1x14TAB)1CARD
Celexa	DISC CELEXA 20MG TABLET SAMPLES  BULK