JSON Data Assembly from Multiple Tables
Budget: $30 – $250 USD
I'm looking for a data expert who can combine information from three tables into a single JSON array.
Requirements:
- Table 1: This table contains unique entries per InvoiceNo. I need the following fields from this table to be included in the JSON array: Dept, InvoiceNo, BackRef, InvoiceDate, SalesMan.
- Table 2: This table has multiple entries per InvoiceNo. Only item details from this table should be included in the JSON array.
- Table 3: This table, like Table 1, contains unique entries per InvoiceNo. Data from this table will not be included in the JSON array.
The key identifier for each invoice in the JSON array will be InvoiceNo.
Ideal skills for this job:
- Proficiency in data manipulation and JSON formatting
- Experience in handling and combining data from multiple tables
- Strong understanding of data structures and identifiers
- Knowledge of invoice-related data processing
Requirements:
- Table 1: This table contains unique entries per InvoiceNo. I need the following fields from this table to be included in the JSON array: Dept, InvoiceNo, BackRef, InvoiceDate, SalesMan.
- Table 2: This table has multiple entries per InvoiceNo. Only item details from this table should be included in the JSON array.
- Table 3: This table, like Table 1, contains unique entries per InvoiceNo. Data from this table will not be included in the JSON array.
The key identifier for each invoice in the JSON array will be InvoiceNo.
Ideal skills for this job:
- Proficiency in data manipulation and JSON formatting
- Experience in handling and combining data from multiple tables
- Strong understanding of data structures and identifiers
- Knowledge of invoice-related data processing