Best data practice

David Song

Hi everyone,

I have the below mater table example.

https://docs.google.com/spreadsheets/d/1-myeymEAC0ru6jb3_7Ly6J53dAsthMN1ASIdi30blNw/edit?usp=sharing

Attribute set A table AND Attribute set B table are the expected results.

Is the best practice to import the master table (actual data has more than 600 columns and over 70k rows) into Xano via CSV and use the API filters to get the expected result?

Or should I processed the data as per expected result then import into Xano?

Thanks,

David

Chris Coleman

Hi, David. A little bit unclear here; are the attributes unique to each SKU, or do you have a standard set of attributes that may or may not apply to each SKU?

David Song

Hi Chris @Chris Coleman ,

Thanks for your comment. I have a standard set of attributes that may or may not apply to each sku.

Regards,

David