Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
You need to add NoConcatenate before Produto:
or Rename
Produto:
LOAD
Id as newID,
Replace(Produto,'Çaia','Saia') as NewProduto
Resident Temp;
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
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;
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
Thank Guys!! ❤️