Morning all...
I have a query that runs on a regular basis against a .csv file. One of my first steps is to unpivot a variable number of columns to convert them into product list (attribute) and unit (value) columns. When filtering, after the unpivot, the attribute column will show a "List may contain extra values" warning. I've been unable to find anything explaining why the warning occurs or how to avoid it...Can anyone provide some insight into the meaning of the warning message? Interestingly, if i look at the individual columns before unpivoting, they all show "List may be incomplete" as expected...
I have a query that runs on a regular basis against a .csv file. One of my first steps is to unpivot a variable number of columns to convert them into product list (attribute) and unit (value) columns. When filtering, after the unpivot, the attribute column will show a "List may contain extra values" warning. I've been unable to find anything explaining why the warning occurs or how to avoid it...Can anyone provide some insight into the meaning of the warning message? Interestingly, if i look at the individual columns before unpivoting, they all show "List may be incomplete" as expected...
