Hello Team, I created the script for data preparation and connecting to SQL Server for checking the unique values based on Join function. When ever i ran the script for open database the output table name similar like "SQL Scripts 1", so i cannot use this table name for further proceedings due to new name show when ever Run. How to set common JMP table name has output from Database. I need to give SQL statement for Table name for output.
Here is the Script is use:
Open Database(
"DSN=SQL Master_USFLI-WAS101;UID=SVC_TableauReader;PWD=***********;APP=JMP;WSID=*********",
"SELECT DISTINCT Individual_Claim_Number_ID_Full FROM [dbo].ALL_CUSTOMERS
WHERE Inteva_Customer_Name = 'PSA'
AND Inteva_Plant_Name_1 = 'SAL'
AND Inteva_Program_Name = 'S3M'
SET ALL_CUSTOMERS = ‘Table name’"
);
Thanks.