Concatenate Issue

[#1]

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]

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]

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.