Comma separator in if-else-if output

Ask for Help
1

Hey Guys,

I need to get an output out of if else if which is numerical input and output.

the Input reads 111,222,333

But output comes as 111222333

Is there a way to still hold the input with comma separator as the output of if-else-if?

Thank you guys!
Regards,
Dilip

2

Depends what the if-then-else is referring to other than the input column, and how those columns are configured.

Please show screen shots of:

  • the if-then-else column configuration
  • all columns that it refers to
3

Hi Darren,

Please find the screenshot attached

Screenshot 2024-02-22 at 4.45.04 PM
Screenshot 2024-02-22 at 4.45.04 PM1978Ă—1348 135 KB

Blue square portion represents the input with Comma separated values

The Red square portion represents the output

Regards,
Dilip

4

Okay. You would need to trace the source of each of those columns.

But… an easier option is to just add a Math column, point it at your if-then-else column, and re-apply the formatting.

1 Like
5

Thank you for the solution Darren, I did that actually , As it would need adding of another column I was wondering Would that be an ideal way or would there be any other way without having to add extra column?

Regards,
Dilip

6

I don’t know. I would need to look at every single column that feeds into that if-then-else column, and every single column that feeds into every single one of those, and so on, all the way back to the first non-computed column, and confirm that every column that is referenced in the whole chain is a number type. I don’t have the time or energy to lead you through that. But you’re quite welcome to have a go at it by yourself, it could be a good learning exercise.

7

Thank you Jeff, Will check on this and feasibility and revert back.

Regards,
Dilip

8

To me it seems that you are using a comma separator in your initial math columns and the single value columns are keeping this configuration.

The if-then-else else column is changing the format of the number and removing the comma separator.

As Darren suggested, you could add a math column after your if-then-else column for the single purpose of reformatting your numbers with the comma separator. Ideally, the if-then-else column would keep the original formatting or have a number-formatting option, but it doesn’t yet.

9

Thank you Nathan for your reply.

Regards,
Dilip

1 Like
10

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.