Why spaces can not be shown in csv file output in BIP?
3 spaces need to be displayed as the value of a field in csv file output in BIP.
The function is added in the SQL query in the Data Model, and the length of value is 3 bites, but when the file is output as csv, Null is displayed in csv instead of 3 spaces for this field value.
Can you please provide the solution how can we make 3 spaces displayed in csv file output? Thanks.