Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am Rather new to Qlik,
I need help to remove unnecessary characters from some data,
This it what it looks like
Account Number
H0020-01
B0017Teamc
Z1128Sample
B0017dbr
All i need is the First 5 Characters
It Must Looklike this
Account Number
H0020
B0017
Z1128
B0017
Please can anybody Help
Apreciated
Hey,
Here you go:
YourTable:
LOAD
[Account Number],
Left([Account Number], 5) as ID
From YourSource.qvd (qvd);
Hey,
Here you go:
YourTable:
LOAD
[Account Number],
Left([Account Number], 5) as ID
From YourSource.qvd (qvd);
Awesome
Thanks this worked 100%
Appreciate the Help