Formula for Tochar

[RKULKARNI4]

Hello Team,

I am not able to include this formula in Qlik sens.Please  can any one  help me out :

ToChar ( Original_XYZ_No, "0" ) + " "+ ToChar ( Original_XYZ_Date, "0" )

Thanks in advance

Regards

RK

[ArnadoSandoval]

Hi @RKULKARNI4 

Where are you trying to use that expression? Qlik's Load/Select statement is like:

Load c1,
     c2,
     c3;
SQL Select
     c1,
     c2,
     c3
FROM database-table

The TO_CHAR() function is very database specific, perhaps you should elaborate on what you are trying to achieve

Hope this helps,

[Kushal_Chawda]

This is Database function which you can run via qlik sense script using sql query. But if you want this logic to be applied in qlik sense then there could be other qlik function available to do so. For this let us understand your requirement clearly