topic Re: Adding Pseudo Column in the table in QlikView

Adding Pseudo Column in the table

Wed, 21 Aug 2013 12:56:16 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 Pseudo Column in the table

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

You need to decide where YEAR can be calculated from when loading your Table B data.

Then you can calculate your YEAR 'column' while loading the data.

It will be something like:

LOAD TAX, INFO, expression to calculate year AS YEAR;

Table B will then link with table A based on YEAR.

Good luck !

Re: Adding Pseudo Column in the table

abeyphilip — Wed, 21 Aug 2013 13:12:54 GMT

What kind of value are you expecting to be populated in the pseudo year column?

LOAD TAX,

INFO,

'9999' as year1 //dummy year

FROM

C:\XXXX.xlsx

(ooxml, no labels, table is xxx);

load * inline

[TAX,INFO, Year

xx,yy,

dd,mm,];

Re: Adding Pseudo Column in the table

Wed, 21 Aug 2013 13:20:47 GMT

Re: Adding Pseudo Column in the table

Hi abeyphilip

Thank you for your quick response. I may need to have the year field same like below

LOAD TAX,

INFO,

'9999' as year1 //dummy year

FROM

C:\XXXX.xlsx

(ooxml, no labels, table is xxx);

But I should not Hard Code it. I need to have a variable with table B ,it should look in to Table A year field

-Jay

Re: Adding Pseudo Column in the table

Wed, 21 Aug 2013 13:22:10 GMT

Hi Richard,

Thanks for your response. It would be great if you brief more about expression to calculate year AS YEAR; in your solution. Do I need to have any lookups?

-Jai