Loading

Restructuring Data Using Custom SQL

Publiseringsdato: Apr 30, 2025
Oppgave
How to restructure data using custom SQL.
Trinn
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-artikkelnummer

001458238

Vedlegg

Restructure with Custom SQL.twbx

43 KB

test data for Custom SQL.xlsx

45 KB

 
Laster
Salesforce Help | Article