Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

add a prefix to data when loading from excel

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?

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Edit your load script and add it.

Current line of code:

someFieldName,

Change it to

'PRD000' & someFieldName as someFieldName,

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!

View solution in original post

7 Replies
Highlighted
Master III
Master III

Edit your load script and add it.

Current line of code:

someFieldName,

Change it to

'PRD000' & someFieldName as someFieldName,

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!

View solution in original post

Highlighted
Master III
Master III

load

'PRD000'&filedname as field

Highlighted
Contributor III
Contributor III

thank you for the help

Highlighted
Master III
Master III

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 .

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted
Contributor III
Contributor III

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

is this option disabled?

i can find it...

Highlighted
Master III
Master III

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

This image: Community_Correct_Answer.png

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!
Highlighted
Contributor III
Contributor III

No all i have in actions is mark as helpful