Need to union three column values in one column

[#1]

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

[PrashantSangle]

Hi,

If possible can you post sample apps?

and What expression have you tried?

Regards

[ashfaq_haseeb]

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

[tresesco]

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

[#5]

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

[ashfaq_haseeb]

Hi

Can you attach sample to look over

Regards

ASHFAQ