topic Re: Self referencing table in QlikView

Self referencing table

Tue, 17 Nov 2015 08:35:48 GMT

Good day everyone,

I'm currently trying to create a self referencing object, I have a table that represent a warehouse, which I load like this:

Warehouse:

LOAD id AS warehouse_id,

name AS warehouse_name,

warehouse_id;

SQL SELECT *

FROM 'db'.warehouses;

When loading the script this breaks. How can I load this type of tables.

Regards,

Re: Self referencing table

oknotsen — Tue, 17 Nov 2015 08:59:14 GMT

Your current script will fail as the Warehouse table you are trying to create can not have two columns with the same name.

Could you explain what you are trying to achieve? And I do not mean this technical solution, but the problem you are trying to solve.

Re: Self referencing table

dinuwanbr — Tue, 17 Nov 2015 09:37:02 GMT

Hi,

Can you upload a sample here....

Rgds,

Dinu1

Re: Self referencing table

Anonymous — Tue, 17 Nov 2015 09:41:02 GMT

You cant use two same fields in one table, try with renaming one of the field

Warehouse:

LOAD id AS warehouse_id,

name AS warehouse_name,

warehouse_id;

SQL SELECT *

FROM 'db'.warehouses;

Re: Self referencing table

pljsoftware — Tue, 17 Nov 2015 16:35:59 GMT

Hello Aldo,

the correct answer is Re: Self referencing table by balrajahlawat.

In this case a best practice is to comment all fields and start to uncomment a field for each reload. If you do this always you can find which field generate the error.

Best Regards

Luca Jonathan Panetta

Re: Self referencing table

Clever_Anjos — Tue, 17 Nov 2015 16:49:05 GMT

QlikView does not allow two fields with same name

Please read this article, it can help you