Discussion Board for collaboration on QlikView Scripting.
I have a table with:
In the script process i'd like to convert in this format C######
Go to Solution.
You can concat thatWhile Loading
Load 'C' & right('000000'&ID,6)
you could concat 'C'&right('000000'&ID,6)
For example like this:
load num(ID, 'C000000') as ID Inline [
PFA... Hope it will help you
Thank's Saumya ;-)