I begin my process by reading in one table, then joining two others. Everything seems to be okay with the following example statement:
select `Serial Number` as `SerialNumber`,
`Temporary` as ManufacturerSW
But, Temporary does not exist within one of the Tables that is joined. I read in the tables straight from Excel Worksheets. When I dig deep into understanding how DataRobot/Paxata sees the data I go to the Library and find the original Excel file. [Now this has a small number of columns to deal with.] It shows as Column (0) within the environment.
But how may I reference this in the above syntax to select it and at the same time making it into ManufacturerSW?
Please note that I already did a Google search on this and it mostly finds links/solutions for if there are NULLs in the content of the field.