Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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..