8 Replies Latest reply on Nov 14, 2018 4:24 AM by Ombir Rathee

    Not getting the desired output using index() function

    Vijay Santhosh Kumar

      Hi All,


      I use to extract data from Amazon redshift using Alteryx and create a new column called Flag (refer the attached spreadsheet - "Input Used for Desired Output"), which is nothing but if column(B2)= column(B1), then C2+1, else 1, so whenever there is a new serial number it will start with 1 (which i will be using it for reference later) which i have done and able to plot in the required format.

      Now i need to completely automate it, where i need to exclude Alteryx intervention and have to extract the data from the server directly using tableau itself and need to create the same flag, that is also done using index() function. But the issue now is the index function is not giving me the desired view.


      In simple terms, i need to replicate the same view for the current output screenshot as the Desired Output.


      Any help would be really appreciated.


      Kindly let me know if my question is not clear.


      Thanks in Advance,