Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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..

Community Browser