Loading

Restructuring Data Using Custom SQL

Publiceringsdatum: Apr 30, 2025
Uppgift
How to restructure data using custom SQL.
Steg
The following instructions can be reviewed in the workbook attached below.
  1. Connect to data source.
  2. Click Custom SQL.
  3. Click ... to edit the custom SQL statement.
  4. Enter a statement similar to the statement below: 
    SELECT [Sheet1$].[Fruit Batch ID] AS [Fruit Batch ID],
  [Sheet1$].[Number of Bad Fruit_Bruised] AS [Value],
  "Bruised Fruit" AS [Reason]
FROM [Sheet1$]

UNION ALL

SELECT [Sheet1$].[Fruit Batch ID] AS [Fruit Batch ID],
  [Sheet1$].[Number of Bad Fruit_Rotten] AS [Value],
  "Rotten Fruit" AS [Reason]
FROM [Sheet1$]

UNION ALL

SELECT [Sheet1$].[Fruit Batch ID] AS [Fruit Batch ID],
  [Sheet1$].[Number of Bad Fruit_Too Big] AS [Value],
  "Too Big" AS [Reason]
FROM [Sheet1$]

UNION ALL

SELECT [Sheet1$].[Fruit Batch ID] AS [Fruit Batch ID],
  [Sheet1$].[Number of Bad Fruit_Too Small] AS [Value],
  "Too Small" AS [Reason]
FROM [Sheet1$]
  5. Click OK.
Knowledge-artikelnummer

001458238

Bilagor

Restructure with Custom SQL.twbx

43 KB

test data for Custom SQL.xlsx

45 KB

 
Laddar
Salesforce Help | Article