2 Replies Latest reply: Jun 7, 2018 1:32 AM by Kishore Kumar RSS

    loading of multiple tables into qlik sense

    Kishore Kumar

      I can able to bring sheet2,sheet3,sheet4 at the same time because they have same number of fields , but when i add sheet 1(which dont have recordtype) I could't able to because it always end up having error while loading ....

       

      code I wrote in the script


      For i = 1 to 4

      Let vSheetName = pick( i,’Sheet1’,‘Sheet2',’Sheet3’,‘Sheet4’);

      Let vFieldName = pick( i,’’ ,’skills’ ,’behaviour’,’class’);

      Let vRecordType = pick( i,’marksonly’ ,’skills’ ,’behaviour’,’class’);            

      CrossTable(test, markscored, 4)// marks1 and marks 2 under test & values in the marks unders markscored

      LOAD

          firstname,

          lastname,

          '$(vRecordType)' as recordtype,

          $(vFieldName) AS recordvalue,

      marks1,

      marks2

      from(………………………….((ooxml, embedded labels, header is 1 lines, table is $(vSheetName)))

      Next

      let i=Null();        

       

      Message was edited by: Kishore Kumar