Thank you Alex..
I need some more details about this function.I am testing this function with the below scenario.
I am connecting to excel sheet where the first table contains the Order ID as Number and second table contains the Order ID as Text.
connected this to tableau and joined the table using custom SQL.
the sql is below.
[Orders$].[City] AS [City],
[Orders$].[Order Date] AS [Order Date],
CAST([Orders$].[Order ID] AS int) AS [Order ID],
[Orders$].[Ship Mode] AS [Ship Mode],
[Orders$].[Shipping Cost] AS [Shipping Cost],
CAST([Returns$].[Order ID] AS int) AS [Returns$_Order ID],
[Returns$].[Status] AS [Status]
LEFT JOIN [Returns$] ON [Orders$].[Order ID] = [Returns$].[Order ID]
but if I give preview results in Tableau it is throwing an error.can u help me to find out where I did the mistake.
Get rid of the join and see if it still throws an error
I tried that without the join as well.Still the same issue is coming.
The below statement needs to be corrected I guess.
CAST([Orders$].[Order ID] AS int) AS [Order ID]
I don't think you can use Cast - you have to use one of the functions on that link