duplicate values

[#1]

Com_Key	LDAP Group
FRM ANALYTICS_rramirez	MCCO FRM OPS
FRM ANALYTICS_rramirez	MCCO BFRM
FRM ANALYTICS_rramirez	MCCO AREAMGR IFRM

i have two cols as mentioned above if i click com_key then any one of the LDAP Group should show,

below is my existing script

Meta_Con:

LOAD

  [Dashboard App]&'_'&[Unix ID] as Com_Key,

  upper([LDAP Group]) as [LDAP Group],

  [Unix ID] as [Unix_ID]

[rubenmarin]

Hi karthikeyan,

QV only stores different values, so internally it has that Com_Key "FRM ANALYTICS_rramirez" is associated to LDAP Group "MCCO FRM OPS", "MCCO BFRM" and "MCCO AREAMGR IFRM".

So when you click Com_Key, all LDAP Groups associated are filtered. If you have list boxes with Com_Key and LDAP Group you can check the behaviour.

[#3]

hi ruben

is it not possible to show any one value in ldap group

[rubenmarin]

Values aren't shown in a list box? List Box will show all values stored in [LDAP Group] by default, even if they are not related to any other field.

If you try to show [LDAP Group] in a text box or graph expression you can use Concat() funtion to show all values:

Concat([LDAP Group])

[#5]

yes i want to show this in a st.table

if i click com_key only one ldap group should show is it possible

[rubenmarin]

You can use minstring() or maxstring() functions to get the first or last group alphabetically:

MinString([LDAP Group])

[jagan · Accepted solution]

Hi,

Try MaxString() or MinString()

Straight Table:

Dimension: Com_Key

Expression: MinString([LDAP Group]) OR MaxString([LDAP Group])

OR If you want to handle this in script try below script

Meta_Con:

LOAD

  [Dashboard App]&'_'&[Unix ID] as Com_Key,

  upper([LDAP Group]) as [LDAP Group],

  [Unix ID] as [Unix_ID]

FROM DataSource;

MaxGroup:

LOAD

     Com_Key,

     MaxString([LDAP Group])  AS MaxLDAPGroup

RESIDENT Meta_Con

Group By Com_Key;

Now use this column wherever you need.

Hope this helps you.

Regards,

Jagan.

[#8]

thank you sir...