Discussion Board for collaboration on QlikView Scripting.
I have small problem. I have 3 different tables. in the 3rd table one column data are common in another 2 tables.
Here below i have shown a sample tables. here are Tables 1,2,3. If you notice in Table 1 & 2 the Column A & C data will be in Table 3 Column F. So Kindly help how to link the Table 1 & 2 with Table 3.
Thanks In Advance
Table 3 and 2 will be linked on field D. If field A in table 1 is the same as field F in table 3 then rename A to F so tables 1 and 3 will be linked on that field.
Likewise i need to link all the there table using Field A,C & F. Because for example i showed this table. but in real time the fields are different. I do have link Table 1 & 3 by renaming the field name, but likewise if i do for the Table 2 & 3 am getting Sync error. so how to avoid this issue. kindly help wit5h this.
Thanks in advance
As said by Gysbert qlikview is a associative model tool. If the table or field names are similar it will automatically link the tables. If field A and F are similar rename A to F tables 1 and 3 will automatically linked.