Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field a table that looks like this.
ID | Type |
---|---|
300 | Jim,Dave,Scott |
500 | Ron,Betty,Jeff |
600 | Sara,Nick,Nick |
When loading into Qlik I need only the charteres to the left of the first comma in the type column. The result should look like this.
ID | Type |
---|---|
300 | Jim |
500 | Ron |
600 | Sara |
Any help??
Thanks in advanced.
May be like this:
LOAD ID,
SubField(Type, ',', 1) as Type
FROM ....