Concatenate on several fields not work

[#1]

Hi,

I have a question, i have two tables let's say table A and table B. Table A has 4 fields,

KEY          YEAR          WEEK          YWEEK

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

Table B also has 4 fields like table A, i want to concate table A with table B. Field KEY and YWEEK from table B successfuly concate to table A, but FIeld YEAR and WEEK from table B not working. do you know the problem ? Really appreciate your help.

Thanks

UPDATE:

When i convert WEEK from table B using "NUM" function, the concate not working. But when i use WEEK as TEXT it's working. But i need to convert WEEK into number format.

Regards,

Indra

[miranrai]

Hi,

If two tables are having same columns in both table then it will auto concatenate both table. Qlikview is case sensitive check your column names.

[#3]

Hi Mira,

Column name is same. Field WEEK on table A has number format, in the other side field WEEK on table B has text format. So i change WEEK on table B into number format using NUM function, the result is not working. but when i'm not convert WEEK on table B into number format (still text format) it's work. Can you give me the solution ?

Thanks

[prabhas277]

hi

give some sample data then that will help to you..

[vardhancse]

Table_A:

LOAD *[Field

KEY         

YEAR        

WEEK

YWEEK

];

Concatenate

LOAD *[Field

KEY        

YEAR        

WEEK

YWEEK

];

Now automatically the Table A and Table B will be concatenated based on the 4 fields.

[#6]

Hi Sasi,

I have try your solution, but it's not the problem.

Field WEEK on table A has number format, in the other side field WEEK on table B has text format. So i change WEEK on table B into number format using NUM function, the result is not working. but when i'm not convert WEEK on table B into number format (still text format) it's work. Can you give me the solution ?

Thanks

[#7]

Hi Indra,

Try like this

Table_A:

LOAD *[Field

KEY        

YEAR       

WEEK

YWEEK

];

Concatenate

LOAD *[Field

KEY       

YEAR       

Num(WEEK) as WEEK,

YWEEK

];

[#8]

Hi Harsha.

Thanks for the solution, but i have try your solution and it's not working

Another field (KEY, YEAR, YWEEK) sucessfully concate but week is not working and give the result - (stripe symbol)

Do you know the problem ?

Thanks

[#9]

I think it is creating NULL values(stripe symbols) because of Num(WEEK) ...

let me know the values of WEEK field in Table B.....

Generally NUM(WEEK(Timestamp)) will give you the corresponding numeric value for the given week...

[#10]

Values of week in Tabel B ex: 01, 02, 03,.... 10, 11, 12, ...., 52

I think the problem in on converting text to number.