Forum

Expression.Error: T...
 
Notifications
Clear all

Expression.Error: There were too many elements in the enumeration to complete the operation.

2 Posts
2 Users
0 Reactions
1,837 Views
(@staceymiller)
Posts: 3
Active Member
Topic starter
 

Pulling data from the web using an API token ... but the data isn't coming back in a columnar format (due to the advanced filter being used). 

When I don't use a filter in the source, I get the results in the last screen shot of the attached.

How do I convert this query to get the same format as when no filter is being applied at the source?

FYI ... This is a "test" connection.  The actual data that I will be using has 500k+ records that would come back if I don't use the filter in the source.

Thank you in advance for your help!! 

 
Posted : 15/09/2021 10:39 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Stacey,

Add an index column before your unpivot step.

Mynda

 
Posted : 15/09/2021 10:23 pm
Share: