Forum Discussion

BryceBicknell's avatar
BryceBicknell
Frequent Visitor
5 years ago
Solved

Expression Error Column Not Found When Refreshing Data

Hi all,   I receive data on a daily basis in the below format (excel csv), the dates cap at 1815 days with sales by store underneath the dates begining in column H (last column is BRB) and because ...
Need Help
ImkeF's avatar
ImkeF
Community Champion
5 years ago

Hi BryceBicknell ,

there are several ways to do it, but the easiest way would probably be to check columns A-G and use "Unpivot Other columns" instead of you current unpivot that selects the other columns.

 

BryceBicknell's avatar
BryceBicknell
Frequent Visitor
5 years ago

Hi ImkeF,

 

Unfortunately that has the same error, probably because I have promoted the dates row as headers then unpivoted this is bringing the issue of the column not being found as that date no longer exists in the new data but on the oposite end a new date is added, I should have shown the opposite end of the raw data as the rows shown in the first image are blank (dates the stores weren't open) but there are actually values per store see below.