#Mutivalue with Teradata when use FreehandSql dataprovider

[Former Member]

When changing the case lower to upper for columns in the teradata database and when refreshing the report gets #Multivalues.

Any suggestions please.

[Former Member]

Hi,

You can try the following solution to resolve the issue.

To avoid duplicate row aggregation:

1. Select the table, right-click and select Edit Format from the menu.

The Properties tab displays the table formatting options.

2. Select Display > Avoid duplicate row aggregation.

Regards,

Sarbhjeet Kaur

[Former Member]

Hi,

You can either keep it in a column or you can use Max() or Min() function to resolve #Multivalue error.

Regards,

Sanjay

[former_member212749]

Hi,

#Multivalue is the message for showing you that perticular Object is having Multiple values ..Hence you need to keep the Object with any other Column.

Regards

Prashant