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
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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: 
Not applicable
‎2011-03-14 05:08 AM

Loading part of data in LOAD-script

Hello,

I have some data in one tabel that i load from excel looks like:

bat-12345-sat

ch-1254-gat

12-sat-dat

I need to load everything before the first "-". Every row is one field.

Every row is in one field.

1,952 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2011-03-14 05:24 AM
Author

Hi,

see

subfield(YourField, '-' ,1 )

Good luck!

Rainer

View solution in original post

284 Views
0 Likes
1 Reply
Not applicable
‎2011-03-14 05:24 AM
Author

Hi,

see

subfield(YourField, '-' ,1 )

Good luck!

Rainer

285 Views
0 Likes