Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Can you please look into the attached excel and help me to get the expected output.
I have Data sheet, my data is like in the sheet one.
but i wanted to get the data in the sheet "Expected Output",
but the values should show the same.
For example for ID 1 i have three managers and room count is 12, in the expected output it should show the 12 for three managers, if you select three managers ata time it should show 12 only, not 36.
Thanks in advance
Hi,
If possible can you post sample apps?
and What expression have you tried?
Regards
Hi,
Try this, have a look at attached application too.
LOAD ID,
Manager1 as Manager,
Rooms
FROM
[Managers List.xlsx]
(ooxml, embedded labels, table is Data);
Concatenate
LOAD ID,
Manager2 as Manager,
Rooms
FROM
[Managers List.xlsx]
(ooxml, embedded labels, table is Data);
Concatenate
LOAD ID,
Manager3 as Manager,
Rooms
FROM
[Managers List.xlsx]
(ooxml, embedded labels, table is Data);
Regards
ASHFAQ
CrossTable(ManagersType, Managers, 2)
Load ID, Rooms, Manager1, Manager2, Manager3;
Load * Inline [
ID,Manager1,Manager2,Manager3,Rooms
1,AAA,BBB,CCC,12
2,DDD,EEE,FFF,43
3,GGG,HHH,III,22
4,JJJ,KKK,LLL,11
5,MMM,NNN,OOO,22
];
PFA
Hi Ashfaq,
Thanks for the response
I tried it, but all the time the expression is stopped working where i used manager column,
Please suggest what to do
Hi
Can you attach sample to look over
Regards
ASHFAQ