8 Replies Latest reply: Apr 17, 2015 1:21 AM by Ralf Narfeldt RSS

    Multi Load in one store

    Kenny Hua

      Hello,

       

      Actually I need to make some LOAD in one Store. I made a loop for to load everything I need but my STORE only take the last one.

       

      If you have some ideas to fix that.

       

      CONVERT:

      LOAD

        A as Country_Code,

        M as User_Id,

        N as Password,

        E as Refresh_Group

        

      FROM AAA.xlsx (ooxml, no labels, table is DATA)

      where E = 'X';

       

       

      for e = 1 to FieldValueCount('Refresh_Group')

       

        for m = 1 to FieldValueCount('Country_Code');

        let vUserId = FieldValue('User_Id', $(m));

        let vPassword = FieldValue('Password', $(m));

        let vCountryCode = FieldValue('Country_Code', $(m));

       

            YourTable:

            LOAD * FROM [ftp://$(vUserId):$(vPassword)@11.111.11.111/DV/AAA - $(vCountryCode) - AAA.xlsx]

            (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes, table is Feuil1);

            //STORE CONVERT into TABLESv2/AAA.qvd(qvd);

            let vUserId = '0';

        let vPassword = '0';

            NEXT

           

      NEXT

      STORE CONVERT into TABLESv2/AAA.qvd(qvd);

       

      Regards