How to create summary from attached data module

[vikasmahajan]

Dear All,

I have following data model , Which is linked with cost centers using qualify we have attached more than 20 opportunity like this now here my requirement is create a summary like this

Opportunity            Charges

-------------------       ----------------

Opportunity1          545.1

Opportunity2           538.

.

.

.

-------------------------------------

Total                      1083.1

[varshavig12]

This is what you want,

Right ?

[vikasmahajan]

Right ? But you removed table names in script without removing tables names will it possible ?

[varshavig12]

Do you mean that you don't want to join the tables ? Then i guess we need to  use Qualify

And do you have cost center in your master table.

Coz it is not there in the excel, but do exist in your data model.

[vikasmahajan]

yes it  is linked into original data model.

Vikas

[varshavig12]

Something like this:

But this becomes too complicated,

Don't you think so ?

[varshavig12]

Oh then i guess, Sunny can help you in better way.

[qliksus]

May be something like this

Script :

QUALIFY * ;
UNQUALIFY Key,Charge;

Opportunity1:
LOAD
     [Cost Center] as Key,
     [Cost Center],
     Hostname,
     UpdateStatus,
     Manager,
     Application,
     Env ,
     Charge
   
    
FROM
[OpportunityData.xlsx]
(ooxml, embedded labels, table is Opportunity1);

Opportunity2:

LOAD
     [Cost Center] as Key,
     [Cost Center],
     Hostname,
     UpdateStatus,
     Manager,
     Application,
     Env ,
     Charge
    
FROM
[OpportunityData.xlsx]
(ooxml, embedded labels, table is Opportunity2);

QUALIFY * ;
UNQUALIFY Key,Charges,Opportunity1;

load 
      'Opportunity1' as Opportunity1,
      Charge as  Charges,
       Key
Resident Opportunity1 ;

load 
     'Opportunity2' as Opportunity1,
      Charge as  Charges,
     Key
Resident Opportunity2 ;

DROP Field Charge ;