topic Re: Adding values to existing field in the script in QlikView

Adding values to existing field in the script

Sun, 05 Apr 2015 15:30:53 GMT

Hi!

Guys, can anyone tellme how can I add values to an existing field in the script?

For example, I have a field like:

Field1:

I want to add values E,F,G.

The desired result is :

Field 1:

Re: Adding values to existing field in the script

fred_s — Sun, 05 Apr 2015 15:59:32 GMT

Hia Diana,

It depends on the way you load your data.

This one will work:

LOAD * INLINE [

Letterx

];

LOAD * INLINE [

Letterx

];

But you probably have to use the concatenate load and make sure the new data has the same structure/fields as

the original structure.

How do load your data? Is it an ODBC connection? Excel? Txt/CSV?

Share a part of your data and we'll tell you how to..

Grtz Fred

Re: Adding values to existing field in the script

Sun, 05 Apr 2015 18:17:04 GMT

It's CSV. The first table has 6 columns and the second one has only 2 columns that has the same names as the fields in the first tables.

I want to join these two tables as I've written above.

Can I use "concatenate" if the number of fields of these tables isnt the same?

Or do i have to use 'Join'?

Re: Adding values to existing field in the script

fred_s — Sun, 05 Apr 2015 18:19:47 GMT

Hi Diana,

This looks like a 'join'.

Share some example records of your first and of your second table.

Grtz Fred

Re: Adding values to existing field in the script

petter — Sun, 05 Apr 2015 20:28:43 GMT

You can use an "auto concatenate" or a "forced concatenation".

To enable the auto concatenation you will have to add the extra columns on the second CSV by doing a preceding load where you populate nulls or some other appropriate value in the missing columns.

To do a forced concatenation you will have to write CONCATENATE in front of you LOAD statement and then the missing columns will automatically get nulls for the second table.

T1:
LOAD
     Field1,
     Field2,
     Field3,
     Field4,
     Field5,
     Field6
FROM
     [my-file1.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', msq);
    
T2:
CONCATENATE LOAD
     F1 AS Field1,
     F2 AS Field2
FROM
     [my-file2.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Re: Adding values to existing field in the script

sunny_talwar — Sun, 05 Apr 2015 23:13:57 GMT

I feel that it is a concatenate from what you posted in your example above. You can definitely concatenate if the two data sources don't have the same number of columns (those columns which don't match up will remain null).

HTH

Best,

Sunny