Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diwaskarki
Creator II
Creator II

how to bring data seperately?

I have a straight table and a list box. Data in the straight table is displayed according to the filter in the list box. Below is a snapshot.

dsa report image.pngAs you can see in the Master DSA List straight table, I have multiple DSAs in the same row.

This is my script to bring in the DSA.

TextBetween(Replace(Replace(Replace(Replace(ATTRIBUTES, chr(10), ''), ' ', ''), '<String>', ''), '</String>', ','), '<entrykey="SFGROUPOWNER"><value><List>', '</List>') As MAGroupOwners,

MAGroupOwners is renamed as DSA.

What can I do in the script to bring each MAGroupOwners separately in each row? Also, how can I do the same thing in the straight chart? I would really appreciate the help.

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

This will create one record per DSA:

LOAD

  Application,

  Entitlement,

  [Entitlement Description],

  SubField([DSA(s)], ',') As DSA

FROM ...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

This will create one record per DSA:

LOAD

  Application,

  Entitlement,

  [Entitlement Description],

  SubField([DSA(s)], ',') As DSA

FROM ...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vishsaggi
Champion III
Champion III

You mean you want those comma separated values as separate rows? Eg. JLIO, LU5B? May be use

Subfield() Function around your textybetween like

Subfield(textbetween(Replace....)), ',')) AS MAGroupOwners

diwaskarki
Creator II
Creator II
Author

Thanks Jonathan.