topic Re: Adding a Pseudo year field in QlikView

Adding a Pseudo year field

Wed, 21 Aug 2013 12:54:54 GMT

Hi All,

I am having the following sceario

Table A

YEAR,FLAG

2012,Y

2013,N

Table B

TAX,INFO

xx,yy

dd,mm

Table C

ID,Details

xx,abc

dd,jjj

From the above tables,even though I dont have any common key field between Table A & B I need to create a Pseudo column of Year in Table B,Then I need to make a relationship to the table C.

All I want to know ,here how to create a Pseudo Year field with the Table B based on Table A

-Jay

Re: Adding a Pseudo year field

alexandros17 — Wed, 21 Aug 2013 12:57:56 GMT

Table B

TAX,INFO

xx,yy

dd,mm

left join

select distinct year as year from Table A

in this way all records for table B will have all yhe years in table A

Hope it helps

Re: Adding a Pseudo year field

Wed, 21 Aug 2013 13:03:58 GMT

Hi,

Thanks for your quick response. If I do the Left Join I can have the year in Table A but,there is no Key field between those. In my real time data it will slow down my Reloading process. So obviouslly I need to create a link of Year field in Table B

-Jay

Re: Adding a Pseudo year field

alexandros17 — Wed, 21 Aug 2013 13:07:13 GMT

The join is Table B left join Table A, in this way you will add the field year as previously descripted.

Let me know ...

Re: Adding a Pseudo year field

Wed, 21 Aug 2013 13:12:56 GMT

Hi Alexandros17,

Thanks again for your quick response. I hope am not clear in my scenario.The Table B dont have any Year field with it. So even though if we do the Left join it will force the Year field to Table B from A. But the reload time,Object retrival time will be high in my dashboard then. So instead of simply doing the Left Join I need to create a Pseudo Year Field to make a perfect relationship.

-Jay