Skip to Content
author's profile photo Former Member
Former Member

How to group records in Bex Query Designer

Hi all, I am new to Bex.

In Bex designer, i want to group Customer in to Groups.

Ex:

Customer Customer 1 Customer 2 Customer 3 Customer 4 Customer 5 Customer 6 Customer 7 Customer 8

Condition:

If (Customer = "Customer 1" or "Customer 2") then "Group A" else if(Customer = "Customer 3" or "Customer 4") then "Group B" else "Group C"

How can i achieve this in Bex Designer???

Thanks.

Kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 03, 2016 at 03:26 PM

    Hi,

    Why don't you add an attribute, let's call it CUSTGROUP, to your CUSTOMER infoobject? Then do the IF condition in the transformation level..

    OR

    If you want this to be done in query designer, then you may create a STRUCTURE..

    Then create several SELECTION or RKF..

    For example:

    GROUP A = filter this with CUSTOMER values of CUSTOMER1 and CUSTOMER2

    GROUP B = filter this with CUSTOMER values of CUSTOMER3 and CUSTOMER4

    etc.

    Regards,

    Loed

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.