Discussion board where members can get started with Qlik Sense.
i have a 19 million+ rows of data which i need to adjust in load script. But don't know how.
I have prodcts serials with different lengths and i need to add '0's on left side of sales Serials so this can become 30 characters
see the example below.
how do i do that?
Please try the below code and method this will help you!
Table:LOADSaleSerial,REPEAT(0,30-LEN(SaleSerial))&SaleSerial AS SystemSerial;LOAD * INLINE [SaleSerialCCCC8E53616C8E5361212];
This code will add 0s to the left side of the SaleSerial that you are expecting as SystemSerial.
View solution in original post
Thanks a lot, it seems to work
You are welcome