6 Replies Latest reply on Apr 11, 2018 7:12 PM by Qifang Zhou

    JSON Data is Duplicating in Tableau Data Source Connection

    Prasanna Selvaraju

      Hi Tableau Community,

       

      I am currently facing a problem in JSON data , when I connect  Tableau 10.1 JSON Data Source which is causing the data to be duplicated.

       

      For Example :

      My Jason Data structure looks like :

      {"results":{"Daily Active Users":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,15,30,11,2,34,41,37,27,117,33,30,147,101,72,63,116,29,22,22,31,15,16,16,15,7,14,12,12,15,17,8,10,8,9,9,18,12,7,6,12,12,14,13,5,4,5,8,8,12,8,6,4,4,9,6,5,19,16,6,6,18,18,26,12,25,6,6,17,20,12,16,17,7,6,13,20,24,19,24,2,2,21,15,23,24,28,8,3,19],"Weekly Active Users":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,16,39,45,46,68,96,118,121,205,219,235,331,371,395,413,427,422,411,328,280,241,212,126,115,101,92,78,74,75,73,68,71,67,65,63,68,61,61,58,61,62,65,61,56,53,50,49,46,45,42,43,42,41,42,38,35,42,52,52,52,58,66,80,76,81,82,82,83,82,67,66,57,57,58,55,58,68,66,71,70,68,72,70,66,72,79,81,80,81],"Monthly Active Users":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,2,16,39,45,46,68,96,118,129,230,248,264,376,440,482,514,594,603,612,617,627,633,640,644,650,652,656,659,660,666,670,665,651,649,650,638,625,609,599,544,537,525,459,407,367,332,251,236,227,221,212,206,199,191,184,183,181,184,190,182,173,183,184,199,200,210,201,200,206,210,206,204,203,200,201,203,209,218,219,223,218,215,221,227,228,237,254,246,236,243],"Timestamps":["06/01/2016","06/02/2016","06/03/2016","06/04/2016","06/05/2016","06/06/2016","06/07/2016","06/08/2016","06/09/2016","06/10/2016","06/11/2016","06/12/2016","06/13/2016","06/14/2016","06/15/2016","06/16/2016","06/17/2016","06/18/2016","06/19/2016","06/20/2016","06/21/2016","06/22/2016","06/23/2016","06/24/2016","06/25/2016","06/26/2016","06/27/2016","06/28/2016","06/29/2016","06/30/2016","07/01/2016","07/02/2016","07/03/2016","07/04/2016","07/05/2016","07/06/2016","07/07/2016","07/08/2016","07/09/2016","07/10/2016","07/11/2016","07/12/2016","07/13/2016","07/14/2016","07/15/2016","07/16/2016","07/17/2016","07/18/2016","07/19/2016","07/20/2016","07/21/2016","07/22/2016","07/23/2016","07/24/2016","07/25/2016","07/26/2016","07/27/2016","07/28/2016","07/29/2016","07/30/2016","07/31/2016","08/01/2016","08/02/2016","08/03/2016","08/04/2016","08/05/2016","08/06/2016","08/07/2016","08/08/2016","08/09/2016","08/10/2016","08/11/2016","08/12/2016","08/13/2016","08/14/2016","08/15/2016","08/16/2016","08/17/2016","08/18/2016","08/19/2016","08/20/2016","08/21/2016","08/22/2016","08/23/2016","08/24/2016","08/25/2016","08/26/2016","08/27/2016","08/28/2016","08/29/2016","08/30/2016","08/31/2016","09/01/2016","09/02/2016","09/03/2016","09/04/2016","09/05/2016","09/06/2016","09/07/2016","09/08/2016","09/09/2016","09/10/2016","09/11/2016","09/12/2016","09/13/2016","09/14/2016","09/15/2016","09/16/2016","09/17/2016","09/18/2016","09/19/2016","09/20/2016","09/21/2016","09/22/2016","09/23/2016","09/24/2016","09/25/2016","09/26/2016","09/27/2016","09/28/2016","09/29/2016","09/30/2016","10/01/2016","10/02/2016","10/03/2016","10/04/2016","10/05/2016","10/06/2016","10/07/2016","10/08/2016","10/09/2016","10/10/2016","10/11/2016","10/12/2016","10/13/2016","10/14/2016","10/15/2016","10/16/2016","10/17/2016","10/18/2016","10/19/2016","10/20/2016","10/21/2016","10/22/2016","10/23/2016","10/24/2016","10/25/2016","10/26/2016","10/27/2016","10/28/2016","10/29/2016","10/30/2016","10/31/2016","11/01/2016","11/02/2016","11/03/2016","11/04/2016","11/05/2016","11/06/2016","11/07/2016","11/08/2016","11/09/2016","11/10/2016","11/11/2016","11/12/2016","11/13/2016","11/14/2016","11/15/2016","11/16/2016","11/17/2016","11/18/2016","11/19/2016","11/20/2016","11/21/2016","11/22/2016","11/23/2016","11/24/2016","11/25/2016","11/26/2016","11/27/2016","11/28/2016","11/29/2016","11/30/2016","12/01/2016","12/02/2016","12/03/2016","12/04/2016","12/05/2016","12/06/2016","12/07/2016","12/08/2016","12/09/2016","12/10/2016","12/11/2016","12/12/2016"],"success":true},"md5":"XXXXXXXXXXXX"}

       

      When I connect tableau JSON data Source ,  I am selecting the schema of Timestamp and Weekly Active user.
      Tableau output shows is like for Each Timestamp , data is repeating .

       

       

      Ideally after connecting JSON , it should produce data model like below :

         

      Daily
        Active User
      Weekly Active UserMonthly Active UserTimestamp
      0006/1/2016
      0006/2/2016
      0006/3/2016
      0006/4/2016
      0006/5/2016
      0006/6/2016
      0006/7/2016
      0006/8/2016
      0006/9/2016
      0006/10/2016
      0006/11/2016
      0006/12/2016
      0006/13/2016
      0006/14/2016
      0006/15/2016
      0006/16/2016
      0006/17/2016
      0006/18/2016
      0006/19/2016
      0006/20/2016
      0006/21/2016
      0006/22/2016
      0006/23/2016
      0006/24/2016
      0006/25/2016
      0006/26/2016
      0006/27/2016
      0006/28/2016
      0006/29/2016
      0006/30/2016
      0007/1/2016
      0007/2/2016
      0007/3/2016
      0007/4/2016
      0007/5/2016
      0007/6/2016
      0007/7/2016
      0007/8/2016
      0007/9/2016
      0007/10/2016
      0007/11/2016
      0007/12/2016
      0007/13/2016
      0007/14/2016
      0007/15/2016
      0007/16/2016
      0007/17/2016
      0007/18/2016
      0007/19/2016
      0007/20/2016
      0007/21/2016
      0007/22/2016
      0007/23/2016
      0007/24/2016
      0007/25/2016
      0007/26/2016
      0007/27/2016
      0007/28/2016
      0007/29/2016
      0007/30/2016
      0007/31/2016
      0008/1/2016
      0008/2/2016
      0008/3/2016
      0008/4/2016
      0008/5/2016
      0008/6/2016
      0008/7/2016
      0008/8/2016
      0008/9/2016
      0008/10/2016
      0008/11/2016
      1118/12/2016
      0118/13/2016
      0118/14/2016
      0118/15/2016
      0118/16/2016
      0118/17/2016
      0118/18/2016
      0018/19/2016
      0018/20/2016
      0018/21/2016
      0018/22/2016
      0018/23/2016
      0018/24/2016
      0018/25/2016
      0018/26/2016
      0018/27/2016
      0018/28/2016
      0018/29/2016
      0018/30/2016
      0018/31/2016
      0019/1/2016
      0019/2/2016
      0019/3/2016
      0019/4/2016
      0019/5/2016
      1119/6/2016
      0119/7/2016
      0119/8/2016
      0119/9/2016
      0119/10/2016
      0119/11/2016
      0119/12/2016
      1129/13/2016
      0129/14/2016
      1516169/15/2016
      3039399/16/2016
      1145459/17/2016
      246469/18/2016
      3468689/19/2016
      4196969/20/2016
      371181189/21/2016
      271211299/22/2016
      1172052309/23/2016
      332192489/24/2016
      302352649/25/2016
      1473313769/26/2016
      1013714409/27/2016
      723954829/28/2016
      634135149/29/2016
      1164275949/30/2016
      2942260310/1/2016
      2241161210/2/2016
      2232861710/3/2016
      3128062710/4/2016
      1524163310/5/2016
      1621264010/6/2016
      1612664410/7/2016
      1511565010/8/2016
      710165210/9/2016
      149265610/10/2016
      127865910/11/2016
      127466010/12/2016
      157566610/13/2016
      177367010/14/2016
      86866510/15/2016
      107165110/16/2016
      86764910/17/2016
      96565010/18/2016
      96363810/19/2016
      186862510/20/2016
      126160910/21/2016
      76159910/22/2016
      65854410/23/2016
      126153710/24/2016
      126252510/25/2016
      146545910/26/2016
      136140710/27/2016
      55636710/28/2016
      45333210/29/2016
      55025110/30/2016
      84923610/31/2016
      84622711/1/2016
      124522111/2/2016
      84221211/3/2016
      64320611/4/2016
      44219911/5/2016
      44119111/6/2016
      94218411/7/2016
      63818311/8/2016
      53518111/9/2016
      194218411/10/2016
      165219011/11/2016
      65218211/12/2016
      65217311/13/2016
      185818311/14/2016
      186618411/15/2016
      268019911/16/2016
      127620011/17/2016
      258121011/18/2016
      68220111/19/2016
      68220011/20/2016
      178320611/21/2016
      208221011/22/2016
      126720611/23/2016
      166620411/24/2016
      175720311/25/2016
      75720011/26/2016
      65820111/27/2016
      135520311/28/2016
      205820911/29/2016
      246821811/30/2016
      196621912/1/2016
      247122312/2/2016
      27021812/3/2016
      26821512/4/2016
      217222112/5/2016
      157022712/6/2016
      236622812/7/2016
      247223712/8/2016
      287925412/9/2016
      88124612/10/2016
      38023612/11/2016
      198124312/12/2016

       

      EXPECTED DATA MODEL:

       

       

      My Point is , Does JSON File data is getting duplicated by Tableau JSON connector  ? or JSON file format itself wrong ?
      Please guide me , As I am not aware of JSON file structure and JSON DATA.

       

      Your help will solve my PROJECT Issue which is very critical.

       

       

      Thanks in Advance
      Prasanna Selvaraju