topic Re: add a prefix to data when loading from excel in QlikView

add a prefix to data when loading from excel

avishaiz — Wed, 25 Nov 2020 16:16:04 GMT

i have data loaded from excel

the data is a number but want to add the prefix "PRD000" to the field

how do i do that?

oknotsen — Thu, 04 Aug 2016 08:39:25 GMT

Edit your load script and add it.

Current line of code:

someFieldName,

Change it to

'PRD000' & someFieldName as someFieldName,

arulsettu — Thu, 04 Aug 2016 08:40:29 GMT

load

'PRD000'&filedname as field

avishaiz — Thu, 04 Aug 2016 10:33:29 GMT

thank you for the help

oknotsen — Thu, 04 Aug 2016 13:44:26 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

avishaiz — Sun, 07 Aug 2016 10:25:33 GMT

sorry for the late response, i was out of the office

is this option disabled?

i can find it...

oknotsen — Sun, 07 Aug 2016 13:20:30 GMT

You don't see a big green start with the text "Correct Answer" at the end of each post?

This image:

avishaiz — Mon, 08 Aug 2016 07:18:59 GMT

No all i have in actions is mark as helpful