topic Re: Replace with table vs Replace with inline in QlikView

Replace with table vs Replace with inline

Fri, 19 Dec 2014 13:26:18 GMT

Guys....

Why this works:

Produto:

LOAD

Id,

Replace(Produto, 'Çaia','Saia') as Produto

FROM

(ooxml, embedded labels, table is Plan1);

And this doesn't work?

Temp:

LOAD * INLINE [

Id, Produto

1, Camiseta

2, Calça Jeans

3, Jaqueta

4, Saia

5, Çaia

];

Produto:

LOAD

Id,

Replace(Produto,'Çaia','Saia') as Produto

Resident Temp;

DROP Table Temp;

Re: Replace with table vs Replace with inline

jpenuliar — Fri, 19 Dec 2014 13:55:02 GMT

You need to add NoConcatenate before Produto:

Re: Replace with table vs Replace with inline

jpenuliar — Fri, 19 Dec 2014 13:56:32 GMT

or Rename

Produto:

LOAD

Id as newID,

Replace(Produto,'Çaia','Saia') as NewProduto

Resident Temp;

Re: Replace with table vs Replace with inline

jpenuliar — Fri, 19 Dec 2014 13:59:38 GMT

What is Happening is before the script drop Temp table,

Temp and Produto are Concatenated.

If you comment Drop Table Temp and see in Table viewer (CTRL+T), Temp table is doubled

Re: Replace with table vs Replace with inline

Fri, 19 Dec 2014 14:17:31 GMT

Hi Lorena,

You are loading the same fields second time and they are merging into once table, then you are dropping that table. so, you need to rename the fields in the resident load. Please find the attachment

Temp:

LOAD * INLINE [

Id, Produto

1, Camiseta

2, Calça Jeans

3, Jaqueta

4, Saia

5, Çaia

];

Produto:

LOAD

Id as IdNew,

Replace(Produto,'Çaia','Saia') as ProdutoNew

Resident Temp;

DROP Table Temp;

Re: Replace with table vs Replace with inline

Anonymous — Fri, 19 Dec 2014 14:22:50 GMT

hi,

try:

Temp:

LOAD * INLINE [

Id, Produto

1, Camiseta

2, Calça Jeans

3, Jaqueta

4, Saia

5, Çaia

];

NoConcatenate

Produto:

LOAD

Id,

Replace(Produto,'Çaia','Saia') as Produto

Resident Temp;
DROP Table Temp

Regards

Neetha

Re: Replace with table vs Replace with inline

Fri, 19 Dec 2014 15:07:30 GMT

Thank Guys!! ❤️