Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you share a .xls sample plz ?
I think you should use subfield() function to organize your data in the way you want
HI
I think attached file help you..