Semi-Structured To Structured Data Conversion Using Talend In Snowflake

  • Json
  • Csv
  • xlsx
  1. Drag and drop Restaurant_ID of the main component towards the Restaurant_ID of lookup component to enable join on this column.
  2. Click on tMap settings and change the Join Model to Inner Join.
  1. Click on Add Output table button and give a name to the output to be obtained. Drag and drop the required columns to the matched_output.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store