Read Array Type Field -- FieldList

[#1]

Hi Folks,

I read the Excel file data into QV application. But I got the data below patten.

L-ID	M-ID	T-ID	Groups Combination
A	B	C	[[RC1[RC1BOATA:RC1BOATB]]:[RC2[RC2BOATA:RC2BOATB]]]

and my desired out put table format like

L-ID	M-ID	T-ID	Process Flow
A	B	C	RC1-RC1BOATA
A	B	C	RC1-RC1BOATB
A	B	C	RC2-RC1BOATA
A	B	C	RC2-RC1BOATB

Please help how to read in qlikview.

Thanks in Adnavce....

Regards,

Siri

[christophebrault]

Hi,

Can you share a .xls sample plz ?

I think you should use subfield() function to organize your data in the way you want

[MayilVahanan]

HI

I think attached file help you..