topic Re: Connection in QlikView

Connection

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise

From the OLEDB im trying to get this below table as shown in the screenshot .

And converting the Impact_ID into text

Is this the right way of pulling ?

If you look at line 12 there is SQL SELECT * FROM " Customer_Dell".Payroll;

Is it correct ?

JUst confused with this

Please do suggest .

Thanks in advance

Re: Connection

Anil_Babu_Samineni — Mon, 11 Dec 2017 06:32:23 GMT

Yes, till we are in good. So, what does text() uses in your script?

Re: Connection

avinashelite — Mon, 11 Dec 2017 06:33:16 GMT

what the purpose of converting it to text ? whether it to get the numbers correct ? then I would suggest to convert the Impact_ID to text in the SQL level that is the ideal way to do

Re: Connection

smilingjohn — Mon, 11 Dec 2017 06:37:22 GMT

Hi Avinash .

Becuase Impact_Id as bt numbers and text ...therefore i have to convert this into text..

Becuase one more table which is coming from EXCEL has text format too.

Therefore i have to forcefully convert this to text becuase if i dont do this then iam not getting below numbers

9.10. 11.10,15.10

instead it is consodering the above numbers as

9.1,11.1, 15.1 and so on ..

Re: Connection

smilingjohn — Mon, 11 Dec 2017 06:41:17 GMT

Hi Anil.

Text is the alphanumeric combination in the Impact id..

my doubt was like if i use SQL Select * from ...should not make any missmatch as shown in the fscreenshot

Thanks

Re: Connection

avinashelite — Mon, 11 Dec 2017 06:43:47 GMT

the above syntax looks good not issue you could go ahead

Re: Connection

Anil_Babu_Samineni — Mon, 11 Dec 2017 06:44:57 GMT

True, It won't. Will move ahead..