How to editing display text

[#1]

I'm newbie in qlikview and I want to add some tables from excel so that two columns merged into one and the fields in the first column was missing some symbols. I tried to realize it like that :

Table:
LOAD[ID],
name as Name,
Group,
Weight,
prise,
Code,
Code2
FROM
[Table.xlsx]
(ooxml, embeddedlabels)

Where concat(Code=Replace(Code, Chr(6-7), ""), Code2);

but it doesn't works.

Help me, please

[tresesco]

Not sure of your issue. But first look says, some errors:

Table:

LOAD [ID],

      name as SomeName,          // Error1 -

      Group,

      Weight,

      prise,

      Code,

      Code2

FROM

[Table.xlsx]

(ooxml, embedded labels);

//Where concat(Code=Replace(Code, Chr(6-7), ""), Code)        //Error2- after semi colon in the previous line this doesn't work

[mdmukramali]

Dear,

I think your missing alias name.

Table:

LOAD [ID],

      name as Name,          // Missing alias name in our script

      Group,

      Weight,

      prise,

      Code,

      Code2

FROM

[Table.xlsx]

(ooxml, embedded labels);

Where concat(Code=Replace(Code, Chr(6-7), ""), Code)

[#4]

Thank you but it is not problem because I just make a mistake while copying.

[#5]

Change it but still "code" fields don't merge and format how I need

[#6]

Change everything what you say but program throw an error "Поле не найдено(Field didn't found) - <>"

[mdmukramali]

Dear,

can you share the sample file.

so that we can help you.

Thanks,

Mukram

[crusader_]

Hi, Georgy

I don't think that understood your problem properly,

but what do you mean under

Where concat(Code=Replace(Code, Chr(6-7), ""), Code2)

expression?

If you want concatenate Code and Code2 fields,

you just need add

Code&Code2 as  NewField

in your LOAD statement and there format your values.

If I understood you properly please reply or describe more your issue.

Andrei

[#9 · Accepted solution]

I needed to remove symbols and merge fields.
Thank's a lot. I've realize it like that:

Table:
LOAD [ID],
      Name as Name1,
      Group,
      Weight,
      Price,
      Replace(Code, '::', '')&Code2 as Code
FROM
[Table.xlsx]
(ooxml, embedded labels);

and it works.

[#10]

Thank you. I have already done.