Summary

This operator loads a TIS Table or metadata about the TIS Table into the Data Node. The data from the table can be filtered by a WHERE condition. TIS Parameters can be used for the file name and as parameters in the condition.


Configuration

Settings


Want to learn more?

This operator fetches the content of a TIS table into the data nodes.

Screenshot

Examples

Example: Restaurant 

Situation

A bunch of people in a restaurant ordered some thing to drink these orders where registered in a table that we can now apply queries on.

Who is allowed to drink and what did they order? 

Settings

The Select values are separated by a comma and the Where statement is using the pre-generated table at the bottom of the picture.

Result

Project File

...

Example: Restaurant part 2

Situation

A bunch of people in a restaurant ordered some thing to drink these orders where registered in a table that we can now apply queries on.

Who is allowed to drink and ordered a non alcoholic drink? 

Settings

The Select values are separated by a comma and the Where statement is using the pre-generated table at the bottom of the picture.

The where statement can also be expanded by using an 'and'.

We will also be using the settings on the bottom of the picture to define a 'Query parameter'.

Result

Project File

...

Troubleshooting

Problem

Frequent Cause

Solutions

Error: Cannot read TIS Table


Path is incorrect

Check Table path (e.g., has PATH Parameter been changed)

Error: Cannot read TIS Table

Operation settings "Order by" are wrong (e.g., it looks for 2 columns but your TIS Table has only 1)

Check settings and number of columns in your TIS Table, and adapt settings if necessary

Related topics