topic Re: Differenciate between tables in QlikView

Differenciate between tables

Fri, 13 Dec 2013 14:43:39 GMT

Hi All,

I have two table like:-

Table A:

name,

ID,

salary

Table 2:

name,

ID,

salary,

test

After reloading the data I am able to see only one table in Table A View, if I am droping Table A then I am not able to see any table.

According to my requirement I need to get the data of Table 2 in my file.Kindly help me out to perform this activity.

Thanks,

D J

Re: Differenciate between tables

manideep78 — Fri, 13 Dec 2013 14:49:23 GMT

Hi according to you. those two tables are differing by a column test. Hence they wont concatenate and synthetic keys will be formed. so you can easily drop your first table. if both are having same column name irrespective of their order then they both will concatenate. in this case try below one.

Table A:

Load

name,

ID,

salary

....................

Table 2:

NOCONCATENATE

LOAD

name,

ID,

salary,

test

.............................

Drop table Table A

hope this helps

Re: Differenciate between tables

swuehl — Fri, 13 Dec 2013 14:50:11 GMT

Are you concatenating the two tables? How does your script look like in detail?

Re: Differenciate between tables

Fri, 13 Dec 2013 14:56:59 GMT

I am taking the resident of table A to join in other table. E.X:-

Table A:

Table B:

Load * from Table c;

join

Load ..... resident table A;

Concatinate

Table D;

Re: Differenciate between tables

Fri, 13 Dec 2013 14:57:58 GMT

HI I have explained the condition below.

Thanks for your reply but sorry it's not working.

Regards,

D J

Re: Differenciate between tables

manideep78 — Fri, 13 Dec 2013 15:00:39 GMT

If Table C and Table D contains same fields as Table A then they will automatically concatenate to first table i.e, Table A. Hence If you drop Table A finally no data will exist

Re: Differenciate between tables

Fri, 13 Dec 2013 15:09:27 GMT

Table A and Table D have same fields and yes after droping the table A I am not able to see any data. And I need help on this

Re: Differenciate between tables

manideep78 — Fri, 13 Dec 2013 15:12:05 GMT

Which table data you need? can you please tell me you requirement in detail? If possible post sample app.