topic Re: join solution require in QlikView

join solution require

yadav_anil782 — Fri, 03 Jul 2015 08:31:23 GMT

Hi experts,

I have two table " invoice detaisl"and "payments details"I need to join both table with the coulumn name is "INVOICE_ID" is coumn field.chalages is in join is "inovice id " in invoice details table is repeting and there are unique invoice id given in payments deyails table . So now I need help that what to do to join both table and make only one table because this table I need to add in my final application and i dont want to put these both table there , i want only single tabel with all information from these both table

i have attached excel sheet wiht both table

Re: join solution require

MK_QSL — Fri, 03 Jul 2015 08:38:24 GMT

Isn't there any date field in your Invoice Table?

Except Invoice ID which are the other fields common between two tables?

Re: join solution require

Gysbert_Wassenaar — Fri, 03 Jul 2015 08:40:47 GMT

Why do you need only one table? It doesn't matter for the front end if there's only one table or two properly associated tables. Just rename INVOICE_ID to [invoice id] and your two tables should be linked correctly.

Re: join solution require

jagan — Fri, 03 Jul 2015 08:48:01 GMT

Hi,

It is not mandatory to join the tables into one table, you can have multiple tables which are linked properly. So rename the INVOICE_ID to common case(For example: Invoice_ID) in both the tables, then this tables will join automatically.

Example:

Table1:

LOAD

INVOICE_ID AS Invoice_ID,

FROM FileName;

Table2:

LOAD

[invoice id] AS Invoice_ID,

FROM FileName;

Hope this helps you.

Regards,

Jagan.

Re: join solution require

yadav_anil782 — Fri, 03 Jul 2015 08:57:09 GMT

i need to put this table in my final application there already are morethen 6-7 tables so thats the reson i want only one table

Re: join solution require

jagan — Fri, 03 Jul 2015 09:00:24 GMT

Hi Anil,

If you have Many to Many join then records will be duplicated and sometimes some values will be duplicated, so better not to join those, including single table or multiple is not going to have much difference.

Regards,

Jagan.

Re: join solution require

Gysbert_Wassenaar — Fri, 03 Jul 2015 09:00:55 GMT

So what? There can be dozens of tables in the model. As long as they're properly associated that's not a problem. Anyway, you already know that you need to rename fields either to link or to join the tables.

Re: join solution require

yadav_anil782 — Fri, 03 Jul 2015 09:02:48 GMT

Hi All,

i think my require solution was diffrent , let me explain again

my main motive is only i want to make single table from these two tbales. , because i dont want to put these 2 table in my final appication there are already more then 6-7 tables are there