Need logic help on section.

[lalitkgehlot89]

Hi,

In given data I want to see only CUSTACCOUNT which has the TYPE only Internal on selection.

Please help me out to write the logic.

[lalitkgehlot89]

Here we can create new field with the value like.

Only Internal

Only Former

Only External

Only Miscellaneous

[antoniotiman]

Hi Lalit,

try this

Dimension CUSTACCOUNT

Expression

Only({<CUSTACCOUNT={"=Count({<TYPE>} DISTINCT TYPE)=1"}>} TYPE)

Regards,

Antonio

[its_anandrjs]

In your Excel file there is field TYPE with values Internal, Former, External, Miscellaneous if you select one of this you get the corresponding CUSTACCOUNT and if you have any more field you can filter this CUSTACCOUNT.

What is your requirement?

[effinty2112]

Hi Latit,

You could try a listbox with this expression:

=Aggr(If(Count(DISTINCT TYPE) = 1,TYPE,'Multiple types'), CUSTACCOUNT)

Regards

Andrew

[lalitkgehlot89]

At any end either Script or Front End, which is easy.

[Anil_Babu_Samineni]

Can you look other response Antonio / Andrew too? then come back to thread we will help for sure

[antoniotiman]

Or,

if You want Always TYPE = only 'Internal', try this

Only({<TYPE={'Internal'},CUSTACCOUNT={"=Count({<TYPE>} DISTINCT TYPE)=1"}>} TYPE)

[sumeet-vaidya]

Hi Lalit,

Try below in your script.

Temp1:

Load

     CUSTACCOUNT,

     TYPE

Resident Main_Table

Where Match(TYPE, 'Internal');

NoConcatenate

Temp2:

Load

     CUSTACCOUNT,

     CUSTACCOUNT AS CUSTACCOUNT_Key,

     TYPE

Resident Main_Table

Where Not Match(TYPE, 'Internal');

NoConcatenate

Temp_Final:

Load

     CUSTACCOUNT,

     TYPE

Resident Temp1

Where Not Exists(CUSTACCOUNT_Key,CUSTACCOUNT);

Drop Tables Temp1, Temp2;

Regards,

Sumeet Vaidya