Concatenate and Joins in a new script tab

[#1]

Hi, I have multiple tabs in the script where each tab represents the data of a particular table and the dashboard sheet created. But there are few columns and data with the same names and data that is being used in other dashboard sheets as well. So I am loading the data in a single script tab and used Concatenate and Joins to eliminate the synthetic keys. This made the loading script a single page as compared to the previous individual script tabs. ( For example, earlier, Script Tab A only has data loading for the dashboard sheet A and Script Tab B only has data loading for Dashboard sheet B. Now, there is only single tab where all the data loading is happening and concatenate and joins are used). This is causing some confusion for others as they are not able to understand why the data is being loaded in the single script sheet. Is it possible to load the data in separate tabs and still use the functions of Concatenate and Joins on them? If yes, how.

[#2]

Hi, I still am confused about how to use this.

When you say Table1, Table A, are they the names of the Source files? (In my case, excel sheet names/qvd). Also, seems like load rand() as field1 only loads one field with name field1? Correct me if I am wrong.

If this helps, I am giving the Tab names that I have used as well as the Excel Sheet names for better understanding.

Tab 1:

Load

----

---

FROM
"C:\Users\Desktop\QVD\[AB and BC].qvd"
(qvd);

Outer Join

Load

---

---

FROM
"C:\Users\Desktop\QVD\[XX and YY].qvd"
(qvd);

---------------------------------

My whole intention is to load the files in different tabs and in a new script tab, perform concatenate or Join operations. Please give me the exact syntax with the given names so that it won't be confusing.

[Mark_Little]

There is no difference in syntax between tabs. Just think of it as one long script, at the end of one tab it moves on to the next

Tab 1

Tab1Table:

Load

----

---

FROM
"C:\Users\Desktop\QVD\[AB and BC].qvd"
(qvd);

Tab 2

Outer Join(Tab1Table)

Tab2Table:

Load

---

---

FROM
"C:\Users\Desktop\QVD\[XX and YY].qvd"
(qvd);

You are getting to hung up on a different tabs, they are not different scripts or sub route. It is literally a way to break the code done so it is more user friendly for the people reading it.

[#4]

Thank you so much, I will try these things and see if that serves my use case.

[maxgro]

When you say Table1, Table A, are they the names of the Source files? (In my case, excel sheet names/qvd).

Table1 and TableA are the names you choose for the tables in Qlik.

You can load from an Excel and set the name of the table to Table1 using Table1:

Table1:

LOAD Holiday

FROM

[a exclude holidays.xlsx]

(ooxml, embedded labels, table is Sheet1);

Also, seems like load rand() as field1 only loads one field with name field1? Correct me if I am wrong.

Yes, you're right; rand() was an example.

If this helps, I am giving the Tab names that I have used as well as the Excel Sheet names for better understanding.

Tab 1             // tab name 

Table1:          // the name you choose for the table with the data you're loading from .qvd

Load

----

---

FROM
"C:\Users\Desktop\QVD\[AB and BC].qvd"
(qvd);

Tab 2               // tab name

Outer Join (Table1)              // better if you write the table you use for the join --> outer join (table) instead of outer join

Load

---

---

FROM
"C:\Users\Desktop\QVD\[XX and YY].qvd"
(qvd);

and here you can find an useful pdf about loading data in Qlik

LOAD data into QlikView