1 Reply Latest reply on Mar 9, 2018 1:48 PM by Patrick A Van Der Hyde

    Qualtrics-Tableau WDC refresh issue with integer data type

    Sreejith Ramachandran

      Hi,

       

      I use Qulatrics and use its Tableau WDC to generate some reports in Tableau. There's one numerical field in the output which was loading properly when I initially connected thru WDC. But when I refresh the data, any values above 32767 is getting changed and coming up with a -ve sign. For eg, 32768 becomes -32768, 32769 becomes -32767 etc. It looks like it has something to do with the 16 bit integer range (-32768 to 32767). Any idea why this could be happening? It's pretty urgent and any guidance would be highly appretiated. A few original and refreshed values are listed below.

       

       

      Original ValueAfter Refreshing
      3276132761
      3276232762
      3276332763
      3276432764
      3276532765
      3276632766
      3276732767
      32768-32768
      32769-32767
      32770-32766
      32771-32765
      32772-32764
      32773-32763
      32774-32762
      32775-32761
      32776-32760
      32777-32759

       

      Thanks!

      Sreejith