Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-12-13 03:26 PM

Data Transformation

I have the following data which need some transformation prior to loading into QlikView:

Substitue

Blank

Drug Code

NORMAL SALINE 1LT

35720

GLIBENCLAMIDE 5MG TABLETS

21345

ENALAPRIL 10MG TABLET

7271

ATORVASTATIN 20 MG TABLET

7020

TENOF300MG+LAMUV300MG+EFAV600MG

50468

COTRIMOXAZOLE 480MG TABLET

20828

AMOXYCILLIN 250MG CAPSULE

20381

CIPROFLOXACIN 500MG

20366

HYOSCINE 10MG TABLET

11241

BESEMAX TABLET

2517

The [Drug Code] should be a six digit number.  How can i add preceding zeros to the above to make the [Drug Code] a six number digit at load time?

Regards.

Chris

1,676 Views
0 Likes
12 Replies
Anonymous
Not applicable
‎2014-12-13 04:23 PM
Author

In response to its_anandrjs

Many thanks Anand

172 Views
0 Likes
MarcoWedel
MVP
MVP
‎2014-12-13 04:48 PM

In response to Anonymous

You're welcome

regards

Marco

172 Views
0 Likes
its_anandrjs
Champion III
Champion III
‎2014-12-13 04:55 PM

In response to Anonymous

Thanks It helps you .

Regards,

Anand

172 Views
0 Likes