Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 10, 2022 3:17:46 PM
Apr 16, 2021 9:07:03 AM
When we export data to Excel from a straight table, numeric fields have a 14 decimal format as opposed to the 0 decimal format in the original table.
This is working as designed.
A workaround is to set the number format in the script: '### ### ### ###', '.', ' '
Example:
LOAD
RowNum,
num(GVM, '### ### ### ###', '.', ' ') as GVM
FROM [lib://xyz/Excel/MC_GVM (1).qvd]
(qvd);
QB-1835