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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

How to get the data loaded in a predetermined format

Dear All

I need the data in the table (vehicle number column) to be loaded in the manner how 4th row number is appeared(WP_SY_2530).Hence all numbers need to be arranged 1st two letters then underscore then the 2nd two letters again underscore & the last four numbers. how this could be done?

Many thanks in advance

Neville

SG-JK-254114500
WP-PG-182520000
WP_KN-142512500
WP_SY_253045000
WPLK-152522500
WPOP-285215000
WPXD852025000
10 Replies
nevilledhamsiri
Specialist
Specialist
Author

Sorry, an error on my side!

Thanks  a lot