Forum Discussion

Mike282's avatar
Mike282
Icon for Helper III rankHelper III
9 years ago
Solved

Expanding Tables/Records that are multi-select fields

Hi    Quick question. I've got a datset with combined tables and records that when expanded against the main table, increases the number of rows or records due to the fact that these condensed tabl...
Need Help
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Mike282,

     

    Hi Mike,

     

    How to deal with the multi-values? Keep the first row (record)? Or count them? Let's see an example:

    ComID	Company	
c1	Microsoft	
		
EmpID	ComID	EmpName
e1	c1	Jack
e2	c1	John
e3	c1	Sam

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    One row will turn to three rows after expanding. What do you want to deal with the other two rows?

    Maybe here is your option. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regard!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Mike282,

 

Hi Mike,

 

How to deal with the multi-values? Keep the first row (record)? Or count them? Let's see an example:

ComID	Company	
c1	Microsoft	
		
EmpID	ComID	EmpName
e1	c1	Jack
e2	c1	John
e3	c1	Sam

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

One row will turn to three rows after expanding. What do you want to deal with the other two rows?

Maybe here is your option. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regard!

Dale