-
1. Re: Copy crosstab with decimals
Tushar More Jun 12, 2018 3:31 AM (in response to Diana Lujza Toth) -
2. Re: Copy crosstab with decimals
sudheer.kumar.5 Jun 12, 2018 3:32 AM (in response to Diana Lujza Toth) -
3. Re: Copy crosstab with decimals
Diana Lujza Toth Jun 12, 2018 3:52 AM (in response to Tushar More)I tried but it does not work. I am going to attach an example workbook.
-
4. Re: Copy crosstab with decimals
Diana Lujza Toth Jun 12, 2018 4:06 AM (in response to sudheer.kumar.5)Hi!
I tried it with the attached example workbook and it still does not work.1) if I set the number to currency with 2 decimals, it looks like this in TDE:
then I go to copy-crosstab it puts the decimals in a separate column in Excel:If I set the number to default, it uses simple numbers without decimals. In excel it loses all decimals (and this happens if I set it to currency/number without decimals):
-
Lujza_example.twbx 26.1 KB
-
-
5. Re: Copy crosstab with decimals
Tushar More Jun 12, 2018 4:47 AM (in response to Diana Lujza Toth) -
6. Re: Copy crosstab with decimals
Diana Lujza Toth Jun 12, 2018 5:13 AM (in response to Tushar More)...then I have some other problems which is not related to Tableau. I tried a few times since then, and got the same results, numbers without decimals or decimals in separate column.
thank you for trying to help me!
-
7. Re: Copy crosstab with decimals
sudheer.kumar.5 Jun 12, 2018 5:18 AM (in response to Diana Lujza Toth)1 of 1 people found this helpfulHello Lujza,
Are you using Worksheet -> Export -> Crosstab to Excel option?
The result is below:
If you use Ctrl + A and paste in Excel will give you a different result.
S
-
8. Re: Copy crosstab with decimals
Mavis LiuJun 12, 2018 5:28 AM (in response to Diana Lujza Toth)
1 of 1 people found this helpfulHi Diana,
Your values are being split into two columns because you had set your text to columns to be split:
Thanks,
Mavis
-
9. Re: Copy crosstab with decimals
Diana Lujza Toth Jun 12, 2018 5:37 AM (in response to sudheer.kumar.5)if I use export, the numbers are ok, but this is a big database and exporting is very slow.
Unfortunately I have to send these data to a colleague regularly and I wanted this to do with copy crosstab which is really quick.
Anyway, I tried it again and it works. thank you.