Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Read Array Type Field -- FieldList

Hi Folks,

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

L-IDM-IDT-IDGroups Combination
ABC[[RC1[RC1BOATA:RC1BOATB]]:[RC2[RC2BOATA:RC2BOATB]]]

and my desired out put table format like

L-IDM-IDT-IDProcess Flow
ABCRC1-RC1BOATA
ABCRC1-RC1BOATB
ABCRC2-RC1BOATA
ABCRC2-RC1BOATB

Please help how to read in qlikview.

Thanks in Adnavce....

Regards,

Siri

2 Replies
christophebrault
Valued Contributor

Re: Read Array Type Field -- FieldList

Hi,

Can you share a .xls sample plz ?

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

Re: Read Array Type Field -- FieldList

HI

I think attached file help you..