How to import csv data without select row

Queries and Resources
, , ,
1

image
image1366×768 154 KB

I want to store all data in firebase database.

image
image1366×768 151 KB

This is my query but its return array of object that's why its return error

image
image1366×768 176 KB

2

@niranjan Welcome to the forum:
Try wrapping table2.data like so: {{formatDataAsArray(table2.data)}}

3

image
image1366×768 164 KB

no i am facing same issue.

4

Hey, should you be formatting the data as an object instead of as an array?

5

How to formatting array of object in retools when upload csv file?

6

There's the formatDataAsObject() function. But I have a feeling your data is already shaped as an object. Could you share the shape of table2.data in your left panel state inspector?

7

image
image1920×1080 342 KB

8

File format after import

[{"Manufacturer":"BOSE","Custom Field 10":"03/01/2022","Part Number":"863314-0010","Description":"AMM Speaker Pole Mount Adaptor - M20 Thread","MSRP":"178","Cost":"89","Model":"AMM Speaker Pole Mount Adaptor - M20 Thread","Price":"178","category":"import, not in library","phase":"installation","taxable":"1","custom field 9":"03/31/2022","vendor":"Bose"},{"Manufacturer":"BOSE","Custom Field 10":"03/01/2022","Part Number":"843344-0010","Description":"AMM Suspension Bracket","MSRP":"300","Cost":"150","Model":"AMM Suspension Bracket","Price":"300","category":"import, not in library","phase":"installation","taxable":"1","custom field 9":"03/31/2022","vendor":"Bose"},{"Manufacturer":"BOSE","Custom Field 10":"03/01/2022","Part Number":"843160-0110","Description":"AMM108 Multipurpose Loudspeaker","MSRP":"2656","Cost":"1328","Model":"AMM108 Multipurpose Loudspeaker","Price":"2656","category":"import, not in library","phase":"installation","taxable":"1","custom field 9":"03/31/2022","vendor":"Bose"},{"Manufacturer":"BOSE","Custom Field 10":"03/01/2022","Part Number":"843367-0010","Description":"AMM108 U-Bracket","MSRP":"234","Cost":"117","Model":"AMM108 U-Bracket","Price":"234","category":"import, not in library","phase":"installation","taxable":"1","custom field 9":"03/31/2022","vendor":"Bose"},{"Manufacturer":"BOSE","Custom Field 10":"03/01/2022","Part Number":"829679-0110","Description":"DesignMax DM6C Black","MSRP":"998","Cost":"499","Model":"DesignMax DM6C Black","Price":"998","category":"import, not in library","phase":"installation","taxable":"1","custom field 9":"03/31/2022","vendor":"Bose"},{"Manufacturer":"BOSE","Custom Field 10":"03/01/2022","Part Number":"829726-0010","Description":"DesignMax DM6C Rough-In Kit 6 Pack","MSRP":"198","Cost":"99","Model":"DesignMax DM6C Rough-In Kit 6 Pack","Price":"198","category":"import, not in library","phase":"installation","taxable":"1","custom field 9":"03/31/2022","vendor":"Bose"}]