topic Re: Replace function within hashcode in QlikView

Replace function within hashcode

Anonymous — Tue, 28 Nov 2017 06:30:20 GMT

Hi,

i have hashcode like this:

A'--$Q>F7+O/"ZC.T(3#U,;

And i have to replace sign ' in order to load this to MS SQL Server without errors (MS SQL Server has problem with my hashcode from txt file)

How can i write the replace function?

Thank you in advance,

Jacek Antek

Re: Replace function within hashcode

Anonymous — Tue, 28 Nov 2017 06:32:02 GMT

Hashoce is my uniqueID field:

NoConcatenate

DaneOsobowe2:

load

Text(Hash128(PESEL, Person_ID, Company_shortcut, Department)) as UniqueID,

//PESEL & Person_ID & Company_shortcut & Department AS UniqueID,

Date(Now()) as Data_Zmiany,

*

resident DaneOsobowe;

drop table DaneOsobowe;

RENAME table DaneOsobowe2 to DaneOsobowe;

I think that i have to create another table here and use replace function or maybe do you know maybe better approach?

How this function should look like?

Jacek

Re: Replace function within hashcode

woshua5550 — Tue, 28 Nov 2017 07:08:56 GMT

like this ?

Replace(uniqueID,Chr(39),'something')

Re: Replace function within hashcode

Anonymous — Tue, 28 Nov 2017 07:19:34 GMT

Thank you Dave.

It is possible to do that (creating UniqueID and replace it) within one table?

Or in first table i should create UniqueID and in the next replace it?

Best wishes,

Jacek

Re: Replace function within hashcode

Anil_Babu_Samineni — Tue, 28 Nov 2017 07:26:08 GMT

Perhaps this?

NoConcatenate

DaneOsobowe2:

Load

Replace(Text(Hash128(PESEL, Person_ID, Company_shortcut, Department)), ',', ';') as UniqueID,

Date(Now()) as Data_Zmiany,

resident DaneOsobowe;

drop table DaneOsobowe;

RENAME table DaneOsobowe2 to DaneOsobowe;

Re: Replace function within hashcode

woshua5550 — Tue, 28 Nov 2017 07:29:01 GMT

you can do it in one table like this

Load

Relace(Text(Hash128(PESEL, Person_ID, Company_shortcut, Department)) ,Chr(39),'Something') as UniqueID

From <TableName>

Re: Replace function within hashcode

Anonymous — Tue, 28 Nov 2017 07:41:15 GMT

thank you very much Guys,

this is working !

Best wishes,

Jacek