Style data and Export it to CSV using Angularjs

Question

$scope.exportData = function ($searchProductDetails) {
    alasql('SELECT * INTO CSV("searchProductDetails.CSV",?) FROM ?',[$searchProductDetails]);
        };

searchProductDetails = [
   {
     "@search.score": 1.634418,
     "brandName": "Aashirvaad",
     "productId": "16361",
     "highLevelCategory": "Food",
     "lowLevelCategory": "Flour / Atta",
     "subCategory": "Wheat Flour / Atta",
     "productName": "Aashirvaad Sharbati Atta",
     "productImageUrl": "Cooking_Aashirvaad-Sharbati-Atta.jpg",
     "P1PKBrandsId": 10009
    },
    {
     "@search.score": 1.5750113,
     "brandName": "Pillsbury",
     "productId": "22017",
     "highLevelCategory": "Food",
     "lowLevelCategory": "Flour / Atta",
     "subCategory": "Wheat Flour / Atta",
     "productName": "Pillsbury Chakki Fresh Atta",
     "productImageUrl": "Cooking_Pillsbury-Chakki-Fresh-Atta.jpg",
     "P1PKBrandsId": 10823
    }
]

I don't want to export @search.score, P1PKBrandsId and productImageUrl but now I can export all and I need export in CSV format only.

agershun · Accepted Answer · 2015-12-30 16:39:53Z

1

You can use REMOVE COLUMNS modifier. AlaSQL will remove all unnecessary columns for you. Try this code:

$scope.exportData = function ($searchProductDetails) {
    alasql('SELECT * REMOVE COLUMNS [@search.score], P1PKBrandsId, \
         productImageUrl INTO CSV("searchProductDetails.CSV",{headers:true}) FROM ?',
         [$searchProductDetails]);
};

edited Dec 30, 2015 at 16:39

answered Dec 29, 2015 at 23:42

agershun

4,10742 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

NiranjanK · Accepted Answer · 2015-12-29 07:09:12Z

0

Try below Code:

var productData = angular.copy(searchProductDetails);  
var finalJson =[];  
angular.forEach(productData, function(obj) {
            finalJson.push({"brandName": obj.brandName, 
                "productId": obj.productId,
                "highLevelCategory": obj.highLevelCategory,
                "lowLevelCategory": obj.lowLevelCategory,
                "subCategory": obj.subCategory,
                "productName": obj.productName,
            });
        });

edited Dec 29, 2015 at 7:09

answered Dec 29, 2015 at 6:59

NiranjanK

4372 gold badges6 silver badges23 bronze badges

Collectives™ on Stack Overflow

Style data and Export it to CSV using Angularjs

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related