Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
As 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.
This will create one record per DSA:
LOAD
Application,
Entitlement,
[Entitlement Description],
SubField([DSA(s)], ',') As DSA
FROM ...
This will create one record per DSA:
LOAD
Application,
Entitlement,
[Entitlement Description],
SubField([DSA(s)], ',') As DSA
FROM ...
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
Thanks Jonathan.