Joining using a derived column (formula)
I am trying to join a two worksheets using a derived column as a test.
Worksheet A is fairly standard. Created from raw text imported into ThoughtSpot (Table A).
Worksheet B has a derived column based on the raw data of Table B. It is a substr formula for the first 3 characters [substr( COLUMN ,0 , 3 )].
Trying to create a relationship from Worksheet A which has this column included in the dataset itself joining to Worksheet B where this column only exists as a formula fails every time.
Would like to see why this join doesn't work.
a view is a dataset that is saved from the result of an search query.
you search for : total sales by product. Then filter that to only show last weeks data.
you can save the dataset as a view and use it as a data source in a new query.
Its mostly used for nested queries. Which is essentially the same as the new "In" feature included in version 5.2.
does that make sense?