How to use Inline load in Qliksense if column have special character

[P_Kale]

Hi Team,

I have a data which contains columns having special characters at a start for eg. "% Policy Number". I am trying to load data through inline in Qliksense by following way but data is not getting loaded. Can you pl help to resolve the issue.

ps_load:

Load * Inline [
CHDRNUM
12345678
];

Inner Join

Load
POL_SK,
[%POLICY NO] as CHDRNUM
FROM [lib://TEST.qvd]
(qvd);

[Lucas_Gatling]

@P_Kale  here is a blog post that might be of assistance to you. Even though it's a blog post for QlikView, it should work in QlikSense as well. 

https://community.qlik.com/t5/Design/QlikView-Quoteology/ba-p/1476029

[P_Kale]

Hi ,

Thanks for your help.

I have read the bolg but i couldn't understand how to resolve issue.

Thanks in advance.

[MayilVahanan]

Hi

Based on the script, it looks fine. 

Might be, In ur TEST.qvd , [%POLICY NO] doesn't have values like "12345678".

For testing, you can try like below also

Load
POL_SK,
[%POLICY NO] as CHDRNUM
FROM [lib://TEST.qvd]
(qvd) where [%POLICY NO] = '12345678';

[P_Kale]

Hi,

Thanks for help.

But if I want to push more than 1 policies then how to achieve this also if i put in a where clause then it may slow down the performance. 

Also mentioned policy is available in data. At the time of execution of script it is not giving any error but In table when i taking the column [%POLICY NO]  i am getting % as value in row.

Thanks in advance.

[MayilVahanan]

Hi

Can you post the sample data?

[P_Kale · Accepted solution]

Hi,

Now I have tried the way I have first written a script and now it is giving a out-put.

Surprisingly it won't work first time.

But thanks for your valuable time and also help.

Best Regards,