Data Mapping Block

Map data of a variable or table.

  • Data source
    The source of data to map could be a variable or table.

  • Data map
    The data map is where you match the source fields with the destinations fields by inputting the dot notation. The source can have multiple destinations. For example, when you have data like below

    [
    	{
    		"address": "2204 Volutpat Rd.",
    		"name": "Palmer Porter",
    		"phone": "(251) 595-5203",
    		"email": "phasellus.dolor@aol.org",
    		"postalZip": "8517",
    		"country": "United States"
    	},
    	{
    		"address": "2741 Dis Rd.",
    		"name": "Byron Bowers",
    		"phone": "(563) 717-9312",
    		"email": "mattis.ornare@outlook.couk",
    		"postalZip": "5612",
    		"country": "Costa Rica"
    	},
    	{
    		"address": "Ap #923-7718 Sed Rd.",
    		"name": "Joseph Waller",
    		"phone": "1-897-102-6811",
    		"email": "cras.pellentesque@outlook.edu",
    		"postalZip": "38-251",
    		"country": "Belgium"
    	}
    ]
    

    and have a data map like this.

    data map

    The data will convert to

    [
    	{
    		"email": "phasellus.dolor@aol.org"
    		"full_name": "Palmer Porter",
    		"address": {
    			"street": "2204 Volutpat Rd.",
    			"postalZip": "8517",
    			"country": "United States"
    		},
    	},
    	{
    		"email": "mattis.ornare@outlook.couk",
    		"full_name": "Byron Bowers",
    		"address": {
    			"street": "2741 Dis Rd.",
    			"postalZip": "5612",
    			"country": "Costa Rica"
    		},
    	},
    	{
    		"email": "cras.pellentesque@outlook.edu",
    		"full_name": "Joseph Waller",
    		"address": {
    			"street": "Ap #923-7718 Sed Rd."
    			"postalZip": "38-251",
    			"country": "Belgium"
    		}
    	}
    ]
    
  • Assign to variable
    Whether assign the mapped data into a variable or not.

  • Variable name
    Name of the variable to assign the mapped data.

  • Insert to table
    Whether insert the mapped data into the table or not.

  • Select column
    The column where the mapped data will be inserted.