topic Concatenate Issue in QlikView

Concatenate Issue

Wed, 22 Jun 2011 21:56:34 GMT

Hi Everyone,

I am trying to create a unique key based on Item No and Part Number. They both are fields in my data model.

This is what I have written but it seems its picking only the first part.

For example

Item_Number is 123456

Part_Number is 731AS25Z

and i require this 123456_ 731AS25Z

I have written this line,

Item_Number & '_' & Part_Number as Item_Part

But it doesn't work.

Please suggest,

Thanks,

Regards,

Bikash

nagaiank — Wed, 22 Jun 2011 22:50:48 GMT

I used the following script and it worked for me.

LOAD *,Item_Number&'_'&Part_Number as Item_Part;

LOAD * Inline [

Item_Number, Part_Number

123456,731AS25Z

];

gussfish — Wed, 22 Jun 2011 22:52:49 GMT

Nothing obviously wrong there. Perhaps if you provide more context -

e.g. the surrounding LOAD statement and the structure of the data it

uses - we might be able to see something.