Go Back
Include Blank Space on Record Columns
Publisher
:
Run In Lingk
Description
Browse the knowledge base
Twitter
E-Mail
# _____ _ _____ __ # | __ \ (_) |_ _| / _| # | |__) |___ ___ _ _ __ ___ | | _ __ | |_ ___ # | _ // _ \/ __| | '_ \ / _ \ | | | '_ \| _/ _ \ # | | \ \ __/ (__| | |_) | __/ _| |_| | | | || (_) | # |_| \_\___|\___|_| .__/ \___| |_____|_| |_|_| \___/ # | | # |_| # Project Name - Include Blank Space on Record Columns # Recipe URL - https://app.lingk.io/a/10932/tf/18343 # Description - This recipe shows you how to put spaces as an alias for a select statement column. # Systems - # Connectors - JSON # Data Flows - Single Direction # Connection Type - Static Data # Add Recipe notes / Change log information here! # _____ _ # / ____| | | # | | ___ _ __ _ __ ___ ___| |_ ___ _ __ ___ # | | / _ \| '_ \| '_ \ / _ \/ __| __/ _ \| '__/ __| # | |___| (_) | | | | | | | __/ (__| || (_) | | \__ \ # \_____\___/|_| |_|_| |_|\___|\___|\__\___/|_| |___/ # # CONNECTORS specify what data will be pulled into the in-memory database during processing connectors: # Configure a JSON in your Environment before running this recipe # JSON Setup - https://help.lingk.io/en/articles/74-json-connector-reference ###### Start - JSON connectors ###### # This JSON contains static values that is used as the source data to be processed - name: sourceData type: json properties: jsonObject: > [ { "leadId": "1", "firstName": "John", "lastName": "Thomas", "email": "email@gmail.com"}, { "leadId": "2", "firstName": "Anne", "lastName": "Jacobs", "email": "mkyong123@gmail.com"} ] ###### End - JSON connectors ###### # _____ _ _ _ # / ____| | | | | | # | (___ | |_ __ _| |_ ___ _ __ ___ ___ _ __ | |_ ___ # \___ \| __/ _` | __/ _ \ '_ ` _ \ / _ \ '_ \| __/ __| # ____) | || (_| | || __/ | | | | | __/ | | | |_\__ \ # |_____/ \__\__,_|\__\___|_| |_| |_|\___|_| |_|\__|___/ # STATEMENTS specify how the data should be processed while in memory statements: - statement: print sourceData # In order to have a column with space in it's alias, ticks chars are needed ` INSTEAD of single quotes ' - statement: | (selectSourceData) => SELECT firstName `First Name`, lastName `Last Name`, email FROM sourceData - statement: print selectSourceData # Add more statements to convert, join, aggregrate, transform, and integrate your data
De-duplication Task - JSON Example
Selecting Nested Data in Recipes