Unable to print alphanumeric and numeric values in single column in nPrinting

[Sneha1]

Hello,

I am unable to print alphanumeric and numeric values in single column in nPrinting excel sheet. I tried

1) typecasting to Text in DB2 in QVD

2) wrote text(coulmn name) as Coulmn name while loading in QlikSense script

3) also while creating sheet tried writing =Text(Coulmn name)

4) Tried to format it to Text in Nprinting excel sheet.

None of above method worked. 

The example of values are like
12345, AVF1234, 999999, 45GHB, FFFFRH

The excel output in nprinitng prints values of only one datatype in one column, but i want all the values in single column. 

[Lech_Miszkiewicz]

My understanding is that all values are still printed the only thing is that numbers are also exported as text which is working as designed. 

The workaround I can think of  may include excel functions. So you populate 1 column (for example column C)  with text values all the way, you can hide that column and then use function like below to convert text to numbers where possible

 cheers