topic Load single quotes in inline table in QlikView

Load single quotes in inline table

Tue, 04 Jun 2013 06:11:34 GMT

How do i load 'AC' ,'UB' in inline table ??

When i tried i get AC and UB itself not the single quotes . Tried Chr(39)&AC&Chr(39), But even this doesnt seem to work

sujeetsingh — Tue, 04 Jun 2013 06:19:52 GMT

Vikram ,

It means you are unable to concatenate the strings'AC' ,'UB',

See this sample.

Sokkorn — Tue, 04 Jun 2013 06:38:46 GMT

Hi,

This one should work

[Data]:

LOAD * Inline [

Field1, Field2

1, "'AC'"

2, "'UB'"];

Or you can try with Chr()

[Data]:

Load

Field3,

Chr(39)&Field4&Chr(39) As Field4;

LOAD * Inline [

Field3, Field4

1, AC

2, UB];

Regards,

Sokkorn

saumyashah90 — Tue, 04 Jun 2013 06:39:43 GMT

Hey

Try this

Load * Inline [

"'AC'","'UB'"

];

i.e " 'AC' "," 'UB' "