How to align Text to right

Options
rbonazzoBfw
rbonazzoBfw Registered Posts: 3 ✭✭✭

Hi all,

If I convert numbers into Italian format the data with the , decimal are displayed as strings and misaligned. How can I align the resulting strings right.
Thanks for your help


Operating system used: macOs

Tagged:

Answers

  • Zach
    Zach Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 153 Dataiker
    Options

    Hi @rbonazzoBfw
    ,

    I tried importing your spreadsheet into DSS, and it seems to render correctly for me. This is what it looks like:

    image.png

    In the initial dataset, you can see that the storage type is "string" and the meaning is "Decimal". If I process the data using a Prepare recipe (no steps are needed), the storage type is automatically converted to "double" as expected:

    image.png

    Could you please provide additional information about the issue that you're experiencing?

    1. How are you converting the numbers to Italian format?
    2. Can you please provide a screenshot of what you're seeing?

    Thanks,

    Zach

  • rbonazzoBfw
    rbonazzoBfw Registered Posts: 3 ✭✭✭
    Options

    Hi @ZachM

    thanks for your answer, I use the receipe action to change the format to Italian and then the result is as attached.

    It's a snapshot

    Thanks

    Rinaldo

  • Zach
    Zach Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 153 Dataiker
    Options

    Hi @rbonazzoBfw
    ,

    If I'm understanding correctly, the numbers render correctly like shown in my screenshots when you first upload them, but the format breaks after you convert them to Italian format?

    Could you please provide more information about how exactly you're converting the numbers? For example, if you're using a Prepare recipe, could you please post a screenshot that shows the step that converts the numbers and also shows your column headers?

    Thanks,

    Zach

Setup Info
    Tags
      Help me…