7 Replies Latest reply: Aug 23, 2017 1:47 AM by Hemeswara Reddy RSS

    Combining SQL & Excel file, using Concat or Join function in Qliksense ?

    Santhoh Ashokkumar

      I got confusion on joining two diff datasets. I have loaded SQL dataset & I have created some dashboards. Now, I want to join two fields(columns) from excel file. So, how do I have to do.

      1. In the data load editor, do I have to write scripts in the same auto generated data field or should I open a new connection to write the join script?

      2. What is the correct script to join them ?

      3. Also I have a field name in my excel file, it is not in date format? How do I do it ?

       

      please help me out.

      Thanks.