Newbie, Tableau Prep

@Sai Krishna​ 

Hi, well my answers:

a. Is it possible to use Tableau / Prep as an input tool and how much does it cost? Yes, you can output a flow to publish, writeback to Snowflake.

How much does it cost? Well, it depends if you want to run the flows manually or on a schedule.

If you want to run manually the flows, you would need a creator license. This license gives you Tableau Desktop, Tableau Prep Builder, and the possibility to publish flows to Tableau Online/Server, and run flows on Tableau Online/Server. However, with only this license, you would not be able to schedule flows. ($840/year)

If you need to schedule flows to run, then you need to acquire Data Management Add On, this would let you to schedule flow to run (very recommended). Data Management Add On will give you also Data Catalog, and some excellent new features for centralized RLS, etc.

This cost 5.5 per user/month in your install, and if you need it in Tableau Online, $250/month to use a resource block. Each resource block, will let you run a flow at a same time. Resource block is not needed in Tableau Server, only for Tableau Online.

b. . The old data and new data both should reflect in snowflake?

To achieve this, you can output your flow to two tables in snowflake, one that has the old data, and one with the new data. Then you can create your viz from this two tables.

c. They want to see the data in an editable format and use Tableau Prep as an input tool?

Tableau Prep could serve as an input tool, but through running flows.

d. Can an end-user modify the data in Tableau on fly by visualization the report, and the changes should reflect on underlying database as well as visualization?

Well, this is the most difficult thing, currently Tableau cannot do it directly, but using a Tableau extension it is likely that you can achieve the writeback action. Tableau is currently working on make it even easier with actions extension.

I invite you to watch the TC21 Dev on Stage session on https://tc21.tableau.com/episodes/tableau-conference-2021-devs-stage-3314

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego

Tableau Ambassador

@Catie Hannah​ 

Hi, you may use Ctrl + 0 (Ctrl Key and zero) to set the UI to the default zoom. If you want to zoom out then you can use Ctrl + - (Ctrl Key and minus).

Ctrl + ¿ (Ctrl and open quotation mark) or Ctrl + ¡ (Ctrl and open exclamation mark) (yeah this are latin characters) will allow you to increase UI zoom

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador

In the dialog where you have created a Navigation button, there is an option "Image" instead of "Text". You can make your own transparent pixel, or download one from Wikipedia:

https://en.m.wikipedia.org/wiki/File:1x1.png

The image will fill the button box, but maintain its aspect ratio, so if you have a long rectangle to click on, a square image will not fill it, so you would have to create a transparent rectangle of the correct aspect ratio.

Hi @John Kreeger​ ,

Yes. You can aggregate the data based on the purchase order number.

Here is one of the posts regarding the aggregate.

https://www.tableau.com/blog/data-prep-101-what-aggregate-function-and-how-do-you-combine-aggregated-data-89244

Hope this works for you.

Sunny Kasalawat

hi @Hari Ankem​ ,

at the end we no longer needed this functionality.

however, I did talk to Tableau team & was told that that error message is expected , when one is using Cloud (not Server). They did suggest the workaround: you could try scheduling prep using command line

https://help.tableau.com/current/prep/en-us/prep_run_commandline.htm

the idea behind that would be to use VM, install Prep there & schedule flow as per article above.

@Natsumi Suzuki​ Hi Natsumi

Answer

解決策を説明するために、以下のように表1、表2を再現してみました。

表1

表2

まず、表1と表2の間には、結合に使用できる共通のディメンション（[Reference]）が1つしかありません。(ユニオンを行うには、関係するすべての表において一致した列項目を持っている必要があり、それらの表が縦につなげられていきます）。

表 1 で [Reference] という項目を使用して左結合を実行すると、[Reference] には数字 3 の行が複数あるため、以下の図のように特定の行について重複が発生します。これは、左結合が両方のテーブルに存在する3という数字の各行をそれぞれ結合しようとするために起こります。

今回希望されているような、各行レベルで1対1の結合を行うには、各行が一意であることを識別できるようにする必要があります。

一意である識別を実現する方法のひとつとして、両方の表にそれぞれ新たな列項目を追加し、その新たな項目を使用し2つの表を結合することができます。

ステップ1

表 1 に計算フィールドを作成し、一意に識別可能な値を含む新しいフィールドを生成します。また表1の計算フィールドには [New Reference]と名前をつけます。

If [Code]=’A-1’ and [Reference]=1 then ‘A’

Elseif [Code]=’B-2’ and [Reference]=2 then ‘B’

Elseif [Code]=’B-1’ and [Reference]=3 then ‘C’

Elseif [Code]=’C-3’ and [Reference]=3 then ‘D’

END

すると、新しい列[New Reference]が作成されます。

ステップ2

手順1と同様に、表2上に計算フィールドを作成します。計算フィールドの名前は[New Reference 2]と名前をつけます。

If [Tally]=100 and [Reference]=1 then ‘A’

Elseif [Tally]=200 and [Reference]=2 then ‘B’

Elseif [Tally]=200 and [Reference]=3 then ‘C’

Elseif [Tally]=300 and [Reference]=3 then ‘D’

END

すると、新しい列[New Reference 2]が作成されます。

ステップ3

両方のテーブルに結合するための一意の列を作ることができたので、新しく作成した2つの[New Reference]と[New Reference 2]を使って表1に対して左結合を実行するステップを構築することに進みます。

ステップ4

結合のステップを作成したら、不要な列を削除する新しいステップを作成し、最終的に表3のような状態になるように成形しましょう。

Hi @Macarena Silva​ 

I would suggest you try using a Level of Detail calculation. It would be something like

{FIXED [Product] : SUM([Sales])}

would return the total sales for a product.

Please have a read of

https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod.htm

https://www.tableau.com/about/blog/LOD-expressions

Regards

Donna