Skip to main content

#Name0 debatiendo

I've developed a report that looks like this in the Tableau desktop application:

 

Columns corrupted/missing when published.

 

When i publish this report to the server, this is what I see on the web.

 

Report-on-web.png

 

Note that columns are missing and the data that should be across several columns (the first few listed in the application) are all comma separated in the Description column. Has anyone seen anything like this before?

12 respuestas
0/9000

I created a concatenated field in Tableau Prep. As a result, I ended up with some values that began with - . Tableau Prep had no issue creating these values. I exported the output to a CSV file, and opened it up in Excel. However, for the values that began with - , Excel gave me the #Name? error, which means that Excel recognized that - as being a subtraction symbol. Is there a way I can get Excel to stop thinking that these values are formulas? Thank you!

3 respuestas
0/9000

Hi,

I would like to know if the tabcmd publish operation can also have errors.

I created a script that appends approximately 10GB of data.

I've been using this script for about 7 months and I've never experienced any problems.

I checked the execution process of the script with my eyes and even checked that the command window was closed, but the data was not applied on the tableau server.

Can this happen?

The script used is as follows and the problem occurs only tabcmd publish's line.

chcp 65001

tabcmd login -s ⌗address -u ⌗ID -p ⌗PASSWORD

tabcmd get ...

tabcmd publish ⌗local_path -n ⌗NAME -r ⌗PROJECT_NM --append

echo 'completed'

 

Thank you.

4 respuestas
  1. 22 jun 2023, 2:18

    Hello @Ciara Brennan​ 

    I solved this problem by dividing the file into two.

    And recently I had other problems with tabcmd publish. So I have 2 questions about tabcmd append.

     

    At first, I would like to know the general case where tabcmd append fails.(ex. data shapes or column names are different each other)

    Secondly, I wonder if it is possible to fail to append a file that is a big size of data.

     

    I also have some uncomfortable cases when I execute tabcmd publish through the batch file.

     

    The first case is that the modified time of the data source had been changed too late sometimes although the tabcmd publish batch file is completed. Especially this happens when I append over 10GB of data. I guess it took about 2 to 5 minutes.

     

    The second case is that I everyday append 18GB of data using a batch file(about publish(append) of tabcmd) with the window scheduler. Sometimes, however, it has a fail once about every three months.

0/9000

お世話になります。

取引先名に関してわからない箇所があったため、ご質問させていただきます。

 

〇やりたいこと

・取引先名の姓項目のラベル名を「氏名」に変更

・取引先名の名項目を非表示

 

〇現状

・お客様から頂いたデータはフルネームで1つの項目だったため、「姓」項目にフルネームを入れている

・お客様としてはフルネームを氏名として表示して、名項目は非表示にしたいと考えている

 

〇試したこと・考えたこと

・ラベル名を変更する

 ⇒「取引先名」は変更できても「姓名」までは変更できなかった

・数式で「姓名」を連結して、「氏名」項目を作成する

 懸念点

 ・編集ができない

 ・データローダ、インポートウィザードでデータがうまく入るかどうか

 

#取引先

#Name

5 respuestas
  1. Takaaki Motohashi (PERSOL CROSS TECHNOLOGY CO., LTD.) Forum Ambassador
    31 mar 2023, 3:04

    名 項目のみを非表示にする ということはできないですね

     

    今後のためにも姓名項目は使用し、現在のデータは

     

    ・とりあえず姓項目にすべていれる

    ・目視で姓名を分離してインポート

     

    しかないかと思います

0/9000
Hi,

 

I noticed when copy dash from MS word, the dash will be longer and when someone paste the text into the field, when export to either .csv or .xls, the dash will become question mark. I believe it may be due to encoding. Is there a way to fix this when doing export rpt?

 

Pc – monitor

 

 

 

Pc - monitor
6 respuestas
0/9000

Hello,

I'm new to Conga Composer and trying to create an Excel template that is close to a quote with details from the master object and subqueries for related lists. 

 

In the list of linked records, I need to transform a checkbox field to "X" if it's true and (empty) if false. 

It seems I cannot do that directly in a formula (AFAIK Conga does not interpret merge fields in formulas), so I included the merge field in a cell on the same line and created a dynamic repeating formula where I need the "formatted" info: 

&=&=si(J{r},"X","") ("si" = "IF", my merge field data is in the J column, same line)

 

When I process the template with Conga, the Excel file shows an error in all cells: "#Nom?" (#Name? in english).

 

Looking at the generated formula, I get: 

=@si(J55,"X","")  

 

If I delete the @, the formula works fine. 

 

Any idea why composer adds the arobase sign? 

 

I'd rather avoid creating formula fields in Salesforce each time I need to transform the data in a template. 

 

Thanks in advance for your help!

Damien

4 respuestas
  1. Michael Brown (Salesforce) Forum Ambassador
    20 dic 2022, 16:20

    That at least helps pinpoint the issue to the IF Statement. There must be something wrong with that. Does this syntax by chance work?

    &=&=si(J{r}=TRUE,"X","")

0/9000

One of my Dashboard Cross tab column has value as '- Machine'.

 

While downloading this Cross tab data into CSV file, CSV doesn't recognize and show it as '#NAME?'

 

Can you please help to overcome this issue? Thanks.

2 respuestas
0/9000