Invalid Alias in Dataset View

I'm trying to replace a dataset within a Dataset View and I need to add a filter condition from the new dataset, but when I try to apply the filter or add the column from the new dataset I get an error "Invalid alias: `T2`"

When I changed the dataset, I mapped all the fields from the original dataset to the new one. I can add other fields to my dataset view that are new with the replaced dataset just fine. it's only the one field that I need that is causing the error.

Anyone else see this before and have an idea how to fix it?

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    The error "Invalid alias: T2" suggests there’s an issue with how Domo is referencing or aliasing the columns in the new dataset. Make sure the column name from the new dataset exactly matches the column name you expected in the Data View. Check for leading or trailing spaces also.

    If you copy and paste names, copy them into notepad first and then copy out of notepad. Notepad is a dumb program, and useful for stripping out extended characters like those picked up when you copy from a browser.

    Make sure the alias is correctly defined and does not conflict with other columns. You should also verify you are not using any reserved words or have any syntax issues.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    The error "Invalid alias: T2" suggests there’s an issue with how Domo is referencing or aliasing the columns in the new dataset. Make sure the column name from the new dataset exactly matches the column name you expected in the Data View. Check for leading or trailing spaces also.

    If you copy and paste names, copy them into notepad first and then copy out of notepad. Notepad is a dumb program, and useful for stripping out extended characters like those picked up when you copy from a browser.

    Make sure the alias is correctly defined and does not conflict with other columns. You should also verify you are not using any reserved words or have any syntax issues.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **