Finding the Records

[l8b9plyodvynlk2]

Hi Team,

I have data 

Category Name

Men's Clothes

Women's Clothes

Sportswear

Swimwear

can you please how to resolve this issue 

I'm finding this record where [Category Name] = 'Sportswear'

but unable to finding this record.

where [Category Name] = 'Men's Clothes' 

[edwin]

pls post your script

[saranyadurai]

Hi @l8b9plyodvynlk2 ,

 you  can try this,

where [Category Name] = 'Men''s Clothes' ;

Use single quotes twice in Men's

You can read more about this,

Escape sequences

Thanks

[l8b9plyodvynlk2]

1. it is excuting 

Category:
LOAD [Category Name],
Description
FROM
[D:\QlikTutorials\Qlik classes videos\QWT Analysis.xlsx]
(ooxml, embedded labels, table is Category)
where [Category Name] = 'Sportswear';

2. it is not executing

Category:
LOAD [Category Name],
Description
FROM
[D:\QlikTutorials\Qlik classes videos\QWT Analysis.xlsx]
(ooxml, embedded labels, table is Category)
where [Category Name] = 'Men's Clothes';

[l8b9plyodvynlk2]

Yes, Thanks a lot. its working. thanks for your valuable time😊.