topic Re: Sql with an OLEDB connection - inner join in QlikView

Sql with an OLEDB connection - inner join

Thu, 04 Sep 2014 09:08:00 GMT

Hello,

I'm kind of new on Qlikview an I'm getting problems joining two tables. I have a table with my customer and another table with the differents bills. Each of the table have a column with the customer's code but these two columns have different names. I tried renaming both columns with the same name. It works for the first table, but Qlikview tells me it's imposible for the second one since the name is already taken.

I tried joining the tables in the sql querry like I would do it on website, but nothing works even a simple querry "where" or "group" by"...

Can someone helps me?

Thank you very much!

Re: Sql with an OLEDB connection - inner join

mdmukramali — Thu, 04 Sep 2014 09:11:19 GMT

Dear ,

Please can you share the script.

so that it's easy to help u.

Thanks,

Re: Sql with an OLEDB connection - inner join

vijay_iitkgp — Thu, 04 Sep 2014 09:11:39 GMT

Can you please share sample code you are using

Re: Sql with an OLEDB connection - inner join

jonathandienst — Thu, 04 Sep 2014 09:16:46 GMT

I assume that you mean you are using the rename field command. For your scenario, rather uses aliasing during the load, something like:

for first source:

SQL SELECT ...

Cust_Code As CustCode,

...

for second source:

SQL SELECT ...

[CUSTOMER CODE] As CustCode,

...

Now the fields have the same name and will associate correctly.

HTH

Jonathan

Re: Sql with an OLEDB connection - inner join

Thu, 04 Sep 2014 09:17:55 GMT

SQL SELECT

FO_REFERENCE,

FC_CCLIENT

FROM FC_REFERENCES

INNERJOIN FD_ENTETE_DEVI

ON FC_REFERENCES.FO_REFERENCE=FD_ENTETE_DEVI.FC_CCLIENT

WHERE FO_REFERENCE="HW";

Re: Sql with an OLEDB connection - inner join

vijay_iitkgp — Thu, 04 Sep 2014 09:19:30 GMT

TableA: SQL SELECT ... Cust_Code As CustCode, ...; Inner Join (TableA) SQL SELECT ... [CUSTOMER CODE] As CustCode, .. ;

Re: Sql with an OLEDB connection - inner join

Thu, 04 Sep 2014 09:20:16 GMT

Even when I'm using an alias, it says there is an error 😕

Re: Sql with an OLEDB connection - inner join

vijay_iitkgp — Thu, 04 Sep 2014 09:23:06 GMT

You can also use: TableA: Load *, Cust_Code As CustCode; SQL SELECT * From ABC; InnerJoin(TableA) Load *, [CUSTOMER CODE] As CustCode; SQL SELECT * From DEF;

Re: Sql with an OLEDB connection - inner join

Thu, 04 Sep 2014 09:56:07 GMT

So I tried this method and here is my code:

Test:

SQL SELECT

ENDV_CCLIENT AS CodeClient

FROM FD_ENTETE_DEVI

;

inner join (Test)

SQL SELECT

FO_REFERENCE AS CodeClient

FROM FC_REFERENCES;

And this the error message I get:

ErrorSource: (null), ErrorMsg: (null)

Test:

SQL SELECT

ENDV_CCLIENT AS CodeClient

FROM FD_ENTETE_DEVI

Table introuvable

inner join (Test)

SQL SELECT

FO_REFERENCE AS CodeClient

FROM FC_REFERENCES