Tableau Data source --- views not working after migration to KNIME

KNIME Analytics Platform
1

I’ve been struggling for about a week to get a Tableau Dashboard to work with an output and view that used to be created through Alteryx. We have have fully migrated to KNIME (but I have access to the Alteryx flows still).

I’ve compared all fields, values, and types, and even recreated a manual output step by step using the Alteryx workflow. However, the view still doesn’t behave the same way, even though everything seems to match perfectly.

Does anyone have any creative methods to ensure I’m replacing the data source with exactly the same information as my Alteryx workflow? Are there any known differences in how the Tableau Publisher node functions in KNIME compared to Alteryx?

Part of the issue is that there are two separate sources that are blended. I’ve validated that the fields are aligned and the values are the same using the Table Difference Finder.

Any thoughts or suggestions would be greatly appreciated. Thanks!

2

Hi @aehrenworth,

quite a difficult question. Likely since little details were / could be shared.

Could you share some screenshots of what is not behaving as expected please?

Also, how is the data transferred between Alteryx to Tableau … can you ingest the data manually i.e. via CSV Import just to eliminate that part of the process?

Best
Mike

1 Like
3

Thank you for responding. I figured out the gap in the data. it was combination between:

  • how empty and null results were being handled
  • the type of number (double/integer)
  • string/vs number fields

After a long week of comparing the Alteryx workflow to the KNIME workflows I got it 95% figured out. :slight_smile:

2 Likes
4

You are welcome. I immediately thought of data type inconsistencies. In particular null / missing can be deceiving.

Since there are quite a few moving away from Alteryx, it might be an idea to extend the cheat sheet @armingrudd?

@aehrenworth is there a chance to share two data samples for a better understanding?

1 Like
5

Let me see if I can find one or two basic ones from my example to easily share. A larger part of the problem is these two more complicated workflows were migrated by an independent third-party company early on while I was just starting my upskilling with KNIME.

6

Seems you have surpassed that company then … well done👍

In case you need any assistance, i.e. to optimize the workflows for performance, feel free to ping me.

2 Likes
7

Thanks, I will definitely keep you in mind in the future.

1 Like
8

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