Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ecabanas
Contributor

How to convert customers id in load script

Hi,

I have a table with:

ID

1

20

333

400

In the script process i'd like to convert in this format C######

C000001

C000020

C000333

C000400

thank's guys

Eduard

1 Solution

Accepted Solutions
saumyashah90
Valued Contributor

Re: How to convert customers id in load script

You can concat that
While Loading

Load 'C' & right('000000'&ID,6)

5 Replies
bbi_mba_76
Valued Contributor

Re: How to convert customers id in load script

Hi,

you could concat 'C'&right('000000'&ID,6)

saumyashah90
Valued Contributor

Re: How to convert customers id in load script

You can concat that
While Loading

Load 'C' & right('000000'&ID,6)

Re: How to convert customers id in load script

For example like this:

load num(ID, 'C000000') as ID Inline [

ID

1

20

333

400];


talk is cheap, supply exceeds demand
Not applicable

Re: How to convert customers id in load script

Hi

PFA...   Hope it will help you

ecabanas
Contributor

Re: How to convert customers id in load script

Thank's Saumya ;-)

Community Browser