Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

how to make an another table summary as a new value to the dimension..??

All,

Have permanent students details in table A and contract based students details in table B.

Both students oyees swipe in information is available in table C.

Now we want to show the entire contract based students count as one of the value in a pivot table. where we have to use one of the dimension from table A.

its like GP name is a dimension from the table A and contract is the new dimension value that we are expecting under the GP Name...

is it possible... ??

All tables like A , B and C are connected with Student ID as a common key..

its like below...

GP Name       Count

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

Muthurajan    50

Contract         78

Akshay            90

is it possible to create a insert a new value into a dimension table..

??

1 Reply
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Vishal,

Since I don't know the table's structure, i created something quite simple.

Basically what I did was to map a GP_Name into both tables (Table Permanet is your A table where the field already exists, Contract is the created one).

Mapping

GP_Name:

load * Inline

[

Id,Description

1,Muthurajan

2,Akshay

];

Permanent:

load

*,

ApplyMap('GP_Name',GP_Id,'Contract') as Mapped_field;

load * Inline

[

Id,Name_P,GP_Id

1,AAAA,1

2,BBBB,1

3,CCCC,2

4,DDDD,

];

NoConcatenate

Contract:

load

*,

ApplyMap('GP_Name',GP_Id,'Contract') as Mapped_field;

Load * Inline

[

Id,Name_C,GP_Id

1,xxxx,

2,yyyy,

];

As a result, I get this:

sample.png