topic Re: Renaming Multiple Records by Single Name in QlikView

Renaming Multiple Records by Single Name

Mon, 27 Oct 2014 14:36:23 GMT

Hi All,

I have Product Records with different names that I want to rename the same thing. For example, "S200" ",S200" "200SQL" -- I want all to be named "200" -- is there some kind of 'contains' function in Qlik that allows you to rename records?

Rename Record(Contains '200') as 200

How is this done in Qlik?

Thanks!

David

Re: Renaming Multiple Records by Single Name

SunilChauhan — Mon, 27 Oct 2014 14:39:17 GMT

if(wildmatch(fieldname),'*200*',200,fieldname) as new fieldname

hope this helps

Re: Renaming Multiple Records by Single Name

Mon, 27 Oct 2014 15:09:09 GMT

Thanks for the reply!!

I tried this and the CoreProduct field was blank...

LOAD Company,

if(WildMatch(CoreProduct = '*200*',200), CoreProduct) as CoreProduct,

// CoreProduct,

[Sage Version],

[# of Users]

FROM

Thoughts?

Re: Renaming Multiple Records by Single Name

PrashantSangle — Mon, 27 Oct 2014 15:13:06 GMT

Hi,

Check the syntax you have written it is wrong

Try this

if(WildMatch(CoreProduct,'*200*',200), CoreProduct) as CoreProduct,

Regards

Re: Renaming Multiple Records by Single Name

Mon, 27 Oct 2014 15:16:28 GMT

Thanks, Max. I tried that first. It comes back with no errors, but there is no additional '200' record and all of the product names are the same.

Re: Renaming Multiple Records by Single Name

PrashantSangle — Mon, 27 Oct 2014 15:19:48 GMT

Hi,

Sorry my bad

I had written wrong if

Try this

if(WildMatch(CoreProduct,'*200*'),200,CoreProduct) as CoreProduct,

Regards

Re: Renaming Multiple Records by Single Name

Mon, 27 Oct 2014 15:26:46 GMT

If you know which value it will ALWAYS take.

Just write in the load:

YourValue AS ThatField

For example:

LOAD Company,

200 as CoreProduct,

[Sage Version],

[# of Users]

FROM

-------------------------------

Good luck!

Re: Renaming Multiple Records by Single Name

Mon, 27 Oct 2014 15:35:22 GMT

Thanks All. Max -- your script worked -- thanks!

End game, however -- is to have 3 record names -- it seems that this version of wildmatch is only for one record name.

Now we can define that ,200 and 200 are named "200". What if I want to say ,200 and 200 are "200" AND ,500 and 500 are "500"

Re: Renaming Multiple Records by Single Name

PrashantSangle — Mon, 27 Oct 2014 15:38:40 GMT

Hi,

Then write nested if else

Try like

if(WildMatch(CoreProduct,'*200*'),200,if(Wildmatch(CoreProduct,'*500*'),500,CoreProduct)) as CoreProduct,

Regards

Re: Renaming Multiple Records by Single Name

PrashantSangle — Mon, 27 Oct 2014 15:43:02 GMT

Hi,

Close thread if you get correct answer.

Regards

Re: Renaming Multiple Records by Single Name

Mon, 27 Oct 2014 15:44:29 GMT

Perfect. You the man, Max.