I have a field a table that looks like this.
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.
Thanks in advanced.
May be like this:
SubField(Type, ',', 1) as Type
Retrieving data ...