wahlborn
New Contributor II
Joined 7 years ago
User Profile
User Widgets
Contributions
Creating a SNAP that will assign a value to each record in a dataset by referencing a table of 40,000 values
I have a live dataset of locations that includes the zip code of each individual location. I have a separate table that contains the 40k+ different zip codes in the US, along with what time zone that zip code falls in. I’m trying to understand how to design a Snap that will take the zip code in each record, look it up in the time zone table, and then insert the resulting time zone abbreviation in the original record. I have the time zone table in CSV format, but I’ve also imported it as a SQL table so I can reference it in either format if that helps.1.9KViews0likes1CommentAssistance requested creating pipeline for SQL query-->mapper-->text file
My goal is to execute a SQL query, return data, and format it so that it is accepted by a custom app we run here. So far, I have extracted the necessary data and formatted it using a mapper. The mapper output contains three columns that I need to move into a text file. For example: ColumnA ColumnB ColumnC ColumnD ColumnE DataA1 DataB1 DataC1 DataD1 DataE1 DataA2 DataB2 DataC2 DataD2 DataE2 DataA3 DataB3 DataC3 DataD3 DataE3 I need to output the data from the last three columns in the following format and create a text file: DataC1 DataC2 DataC3 DataD1 DataD2 DataD3 DataE1 DataE2 DataE3 I’ve tried a handful of different snaps, and I haven’t succeeded in getting it to work. Anyone have tips on how to implement this?Solved7.2KViews0likes7Comments