Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
??
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: