Inline Data Representation Issue

[#1]

Dear All,

Is it possible to represent the data in INLINE with space and comma

Ex:  Branch name = [Mumbai, Fort]

Thanks in advance

[Michiel_QV_Fan]

spaces yes but comma no. That is the standard separator.

You can do a load on load and generate the new column as needed:

load City & ','& Other as [New field];

load inline [

City, Other

Mumbai, Fort];

[#3]

Thanks Michiel for the early reply.

Now i want to implement section access[Field Level] based on Branch .

But my baranch contains the data as mentioned above.

Is it possible to apply section access[Field Level] on Branch?

[Michiel_QV_Fan]

I do not know. Please run a test.

You also could ask this question in the scripting group instead of New to QlikView.

[Anonymous]

Works fine with a comma in the data like this :

Data:

LOAD * INLINE [

    Dim, Value

    'A,kl', 1

    B, 1

];