2 Replies Latest reply on Sep 24, 2018 12:58 AM by Prasad M

    Multiple Data Sources

    Prasad M

      Here is the two different data sources are available and expecting the result in one sheet in tableau, could you please help me.

       

      Data Source -1:

         

      Product_TypeLoan AmountSD Amount
      CML100,000500
      ECL150,0001000
      LAL200,0001500
      PLA250,0001900

       

      Data Source-2:

        

      Product_TypeLoan AmountSD Amount
      CML9910
      ECL99920
      LAL9,99930
      PLA99,99940

       

      Expected Result:

         

      Product_TypeTypeCreditDebit
      CMLLoan Amount100,00099
      SD Amount50010
      ECLLoan Amount150,000999
      SD Amount100020
      LALLoan Amount200,000999
      SD Amount150030
      PLALoan Amount250,0009999
      SD Amount190040