Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
I am connecting to a SQL datasource. When I run the SQL script all is well and I can see the values. When I run the same script on QV it is dropping off values in a field.
Please see below examples:
SQL result:
QV result:
Please advise what could be causing the issue ? What is that I need to do ?
Thanks
Hi @skzwane01
Might be, its double line values in SQL.
If you mouse over the values in QV, might be, it will visible complete words.
Hi MayilVahanan,
Thank you for your response. You are 100% correct. I have increased the wrap text cell height to 2 lines and the data is there. How do I go about making the data into one line ?
Kind Regards,
Hi @skzwane01
Try like below
Replace(MP_PDP_LEARNING,chr(10),'') as MP_PDP_LEARNING