Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

Hi,

Can you share a .xls sample plz ?

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

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
MayilVahanan

HI

I think attached file help you..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.