Forum Discussion
expanding record column
clintonbreed wrote:
Hi, i am using sharepoint online as the data source. the columns inside the record that i want is Highlighted in yellow
I'm not familar with Sharepoint, what exact is that in sharepoint, a list or whatever? I'd like to try reproduce your issue if I could get more details.
By the way, could you try to filter your orginal dataset to have only one rows and then try to expand. I doubt it is some performance issue.
The Customer Column is a Lookup to a List where all the Customers and Customer Groups are Listed
If i Take Customer/Business Units and add it as a new Query and convert it to a table, then i am able to Expand the Record. The Only problem is between the 2 Tables, none of the information is the same to create a relationship. that is why i would like to expand the column in the current table it is in.