flags list box

[nareshthavidishetty]

Hi,

I have created two flags as

Initiated as flag1

Not Initiated as flag2

Here i need to show Initiated and Not Initiated status in an list box.

Thanks..

[narendiran]

Hi Naresh,

Use Inline Load or mapping.

[avinashelite]

Create an INLINE table like

LOAD * inline

[

Status

Initiated

Not Initiated

];

then in the script you need to join this with the flags using a link table or you could set a trigger so that whenever the selection is made in the this field it will trigger a selection in the flag1 and flag2

[Gysbert_Wassenaar]

Create a field like this instead: If(Initiated=1, 'Ínitiated', 'Not initiated') as Status

[nareshthavidishetty]

Hi,

The flags were created in two different tables.

Thanks..

[nareshthavidishetty]

Hi Avainash,

I have created an inline but let me know how to link this to the chart.

Thanks..

[avinashelite]

how the Initiated & NOT Initiated values are linked with this flags ?? could you please explain us on the same

[nareshthavidishetty]

Hi Avinash,

Please find below.

CONTRACTS:

LOAD Store_Id as StoreID,

Store_Id as Sign_Store_ID,

     [Activated Date],

    '1' as flag,

    'Initiated' as flag2,

     [eSign Percentage]

FROM

XYZ;

Store_Info:

LOAD

     Store_Id as other_Store_ID,

     'eSign Not Initiated' as flag1

FROM

XYZ;

Thanks..

[avinashelite]

how this flag 1 and 2 are related ??

[Anonymous]

Hi,

Create an table with this values:

Selections:

LOAD DISTINCT flag2 as FlagSelect RESIDENT CONTRACTS;

LOAD DISTINCT flag1 as FlagSelect RESIDENT Store_Info;

Then, on Field Actions, create one action on FlagSelect field, with this actions:

On Select -> Select on field

Field: IF(GetSelectedCount(FlagSelect) = 1 and FlagSelect = 'Initiated', 'flag2',

     IF(GetSelectedCount(FlagSelect) = 1 and FlagSelect <> 'Initiated', 'flag1'))

FieldValue: IF(GetSelectedCount(FlagSelect) = 1,FlagSelect)

Regards!!!