Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I had a requirement to add spaces for few field values.
For example, to add space before B, C, E in Category field
Category | Year | Sales($M) |
A | 2020 | 50 |
B | 2021 | 28 |
C | 2018 | 89 |
D | 2017 | 78 |
E | 2015 | 90 |
F | 2019 | 80 |
expected output should be like below:
Category | Year | Sales($M) |
A | 2020 | 50 |
B | 2021 | 28 |
C | 2018 | 89 |
D | 2017 | 78 |
E | 2015 | 90 |
F | 2019 | 80 |
May i know how to achieve this in QS.
TIA
Space - Chr(160)
@SaiPranathiG you can use below as calculated dimension or in load script to create another field
=if(match(Category,'B','C','E'),Repeat(' ',5)&Category,Category)
I have tried the same before, but space is not adding before text. getting trimmed
Space - Chr(160)