Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jeckstein
Contributor

Load field only up to comma

I have  a field a table that looks like this.

IDType

300

Jim,Dave,Scott
500Ron,Betty,Jeff
600Sara,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.

IDType
300Jim
500Ron
600Sara

Any help??

Thanks in advanced.

1 Reply

Re: Load field only up to comma

May be like this:

LOAD ID,

         SubField(Type, ',', 1) as Type

FROM ....

Community Browser