topic Re: Replace data in QlikView

Replace data

farolito20 — Wed, 26 Dec 2012 14:26:48 GMT

How can I replace data?

I have two tables, and I wanna replace a name:

Table1:

ID,Name,Age

1,Luis,15

Table2:

ID,Name,Age

1,Marina,15

I need put the value for name in the first table, in the second, if the combination of ID,Age is the same

Table2:

ID,Name,Age

1,Luis,15

Re: Replace data

swuehl — Wed, 26 Dec 2012 15:29:46 GMT

You can use a mapping table to replace the names in table 2 with the names of table 1, something along these lines:

Table1:

LOAD * INLINE [

ID,Name,Age

1,Luis,15

];

NAMEMAP:

MAPPING LOAD

ID&'-'&Age as Key,

Name

Resident Table1;

Table2:

LOAD ID,

applymap('NAMEMAP', ID&'-'&Age, Name) as Name,

Age

INLINE [

ID,Name,Age

1,Marina,15

1,Marina,16

];

Re: Replace data

farolito20 — Wed, 26 Dec 2012 15:39:22 GMT

What's ID&'-'&Age?

Re: Replace data

farolito20 — Wed, 26 Dec 2012 15:49:40 GMT

Thanks

Re: Replace data

swuehl — Wed, 26 Dec 2012 15:49:50 GMT

& id the string concatenation operator in QV, so ID&'-'&Age is creating a new string by concatenating field ID and field Age with an additional '-' in the middle (as separator).

As I understood, you'll need to check for same ID and age, then replace the name by the name found in table 1, correct?

Re: Replace data

farolito20 — Wed, 26 Dec 2012 16:18:29 GMT

Yes