Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Expression.Error when Pivoting Colum

All,   I have a column labeled 'Metric' where I have listed out things like Net Sales, EBITDA, COGS, Tax, etc. and another column labeled 'Value with the corresponding values for those metrics. I n...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I believe there was a file that had been appending with the original query that was causing the problem. This additional file did not necessarily have columns that aligned fully with the original query, so there may have been more than one data type in at least one of the columns I was handling. 

    Once I removed this problem file from the source in the query, the pivot column worked like it should. The files do not necessarily need to be in one query; just thought it would be convenient. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I believe there was a file that had been appending with the original query that was causing the problem. This additional file did not necessarily have columns that aligned fully with the original query, so there may have been more than one data type in at least one of the columns I was handling. 

Once I removed this problem file from the source in the query, the pivot column worked like it should. The files do not necessarily need to be in one query; just thought it would be convenient.