Discussion Board for collaboration on QlikView Scripting.
I have a question about data load with subfield() function.
C1 |C2 | C3
a | x/y | m
b | y | n
c | y/z | n
d/e| x | m
In the above table, some columns contains multiple values with separater '/' and
they should be splited. But I'm not sure what column has multiple values before
Simply writing is loading ALL fields with subfield(), but it is not smart.
subfield(C1, '/') as C1,
subfield(C2, '/') as C2,
subfield(C3, '/') as C3
I'd like to make the logic which evaluate the values of each field at loading.
Does anyone help me?
what format is the data you are loading in? Can you use the "delimeter" option on loading?
Hear '123455' this is string formate time .hear how to use delimete ,i.e.time is 12-34-55 whate is function used for written delimeter replay fast friends
You may use:
You may do custom format like :
Left(Fld_name,2) & '-' & Mid(Fld_name,3,2) & '-' & Right(Fld_name,2)