Forum Discussion
data format error but the value returning the error doesn't exist?
Hi -- I can't share the data I am using because it is not public information. However I will do my best to explain the issue. I have a dataset that I am performing several operations on. All ste...
Hello, bit hard to tell without seeing but the two steps id take would be:
1. Make sure that on pivot the Advanced options >>> Aggregate Value Function is set to Don't aggregate
2. Create a step immediately prior that generates an index column which you delete in the subsequent step. An alternate here is to Table.Buffer() but i prefer the UI index method. PQ can be a bit odd with where it takes data from and the inserting an index forces it to readt from the previous step.
Let me know how you go.
Cheers,