topic Re: How to get both tables columns in QlikView

How to get both tables columns

Mon, 08 Jul 2013 12:06:28 GMT

Hi,

I have two tables in different databases but the column names are same when I am trying to reload it is getting Field names must be Unique how to sort this problem can anyone help me.

Re: How to get both tables columns

Mon, 08 Jul 2013 12:14:57 GMT

but I have more than 70 columns in that It's difficult to rename all the columns right?

Re: How to get both tables columns

jagan — Mon, 08 Jul 2013 12:19:03 GMT

HI,

Can you attach sample script? It helps in understanding.

Regards,

jagan.

Re: How to get both tables columns

tresB — Mon, 08 Jul 2013 12:19:20 GMT

I think you can use QUALIFY keyword like:

Qualify *;

Load A,B from ....;

Load A,B from .....;

Re: How to get both tables columns

Mon, 08 Jul 2013 12:22:16 GMT

How to use this Qualify am getting error?

Re: How to get both tables columns

Mon, 08 Jul 2013 12:23:21 GMT

can you tell me How can i add script as it contains vast data.

Re: How to get both tables columns

tresB — Mon, 08 Jul 2013 12:26:19 GMT

Ex:

qualify *;

unqualify TransID; // If you want a certain one not to qualify, else remove this

select * from tab1;

select * from tab2;

select * from tab3;

Only TransID will be used for associations between the tables tab1, tab2 and tab3.

Re: How to get both tables columns

Mon, 08 Jul 2013 12:52:44 GMT

I am trying to use as below it's not working

Qualify Table1;

Table2:

load colu1,

colu2,

etc

from T_tab.qvd

Re: How to get both tables columns

tresB — Mon, 08 Jul 2013 13:01:11 GMT

Don't use table name for qualification. use qualify *; the tables names would be prefixed with the field names automatically.

Qualify *;

load colu1,

colu2

from T_tab.qvd

will generate like T_tab.colu1, T_tab.colu2 fields.

Re: How to get both tables columns

Mon, 08 Jul 2013 13:26:12 GMT

How to get this?

Re: How to get both tables columns

tresB — Mon, 08 Jul 2013 13:32:37 GMT

Amelia,

Where is the confusion? Can you come up with a bit more details where you are getting stuck?

Re: How to get both tables columns

Mon, 08 Jul 2013 13:38:01 GMT

I used Qualify Table1;

Table2:

Load col1,col2,col3 ......

from table2.qvd

but again it's showing sameerror.

Re: How to get both tables columns

tresB — Mon, 08 Jul 2013 13:42:01 GMT

amelia2000 wrote:
I used Qualify Table1;
Table2:
Load col1,col2,col3 ......
from table2.qvd
but again it's showing sameerror.

Qualify can't qualify a table. You have to read my earlier post carefully. Use

Qualify * ;
Load col1,col2,col3 ......
from table2.qvd

Re: How to get both tables columns

Mon, 08 Jul 2013 13:48:27 GMT

To be honest I couldn't able to get as I transformed columns that's the reason I can't use *.

Re: How to get both tables columns

tresB — Mon, 08 Jul 2013 13:57:18 GMT

I think we are not on the same page. Can you please post the entire script you are trying with?

Re: How to get both tables columns

techvarun — Mon, 08 Jul 2013 14:00:35 GMT

can u please post the model table structure?

Re: How to get both tables columns

Mon, 08 Jul 2013 14:01:05 GMT

It's not allowing me to post the script that's the reason earlier I send sample by typing and in INLINE table it's working fine.but the problem is with this.