Unable to make Business Rule Analysis

Four Stars

Unable to make Business Rule Analysis

Hi! First time using Talend!
I'm using Open Studio for Data Quality(6.5) to explore Data Profiling Analysis.
My dataset is in a csv, which I imported using the FileDelimited connection.

The single column analysis went really well, however, when I tried to make a Table Analysis (in this case the Business Rule) I was unable to select my dataset. It said that there are no tables selected. Any ideia?
Thanks in advance!

Forteen Stars

Re: Unable to make Business Rule Analysis

when you do Tables anlysis,you nee to click on "Sletect Tables", as shown in below.Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Unable to make Business Rule Analysis

Did it help you?

In this case thank's to mark this case as resolved (Kudos also accepted).

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Unable to make Business Rule Analysis

This is what I have, I've selected the table on the left however it says that I did not.. What I'm I doing wrong?Capturar.PNG

Forteen Stars

Re: Unable to make Business Rule Analysis

what is the DB type and do you have permession to get the table for the user,which you are using?
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Unable to make Business Rule Analysis

I'm importing a csv directly into the Talend. Not using a database..
António Lorvão
Forteen Stars

Re: Unable to make Business Rule Analysis

first do not select metadata and expand the Columns and select the Columns then yow will get into right side.

 

Select Tables>>Expand Metedata>> and select Columns

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Unable to make Business Rule Analysis

Still get the same error..
Forteen Stars

Re: Unable to make Business Rule Analysis

Can you show the the way how your doing? what was the error?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Unable to make Business Rule Analysis

I imported the csv file as a File Delimeted File. Single Column Analysis is working fine, however, I can't make table analysis.

Forteen Stars

Re: Unable to make Business Rule Analysis

From the Selection screen shot, uncheck the Enrollments and check only Columns ,then you will get into the right side window and click on OK.

 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Unable to make Business Rule Analysis

If this help please give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Unable to make Business Rule Analysis

I still get the error... What I'm I doing wrong?

Forteen Stars

Re: Unable to make Business Rule Analysis

Can you check the Columns check box and show me?
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Unable to make Business Rule Analysis

If I try to check the Columns checkbox, it automatically checks the Enrolment checkbox
Forteen Stars

Re: Unable to make Business Rule Analysis

that is ok,when you checK the Columns it should display all coumns in right side section.

can you share your excel and screenshot of the issue please?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Unable to make Business Rule Analysis

I can't share the Excel Smiley Sad It's private information.. But I have the error in the figure. As you can see, I have all the columns in the right selected. I also tried to select only in the right, but I still get the same error..

Forteen Stars

Re: Unable to make Business Rule Analysis

Can you check the file has not corrupted?
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: Unable to make Business Rule Analysis

The single column analysis works everytime.. So the file shouldn't be corrupted..

Four Stars

Re: Unable to make Business Rule Analysis

Still Nothing

Two Stars

Re: Unable to make Business Rule Analysis

I have the exact same issue trying to select columns from a csv file. Any resolution?


@antoniolorvaowrote:

Still Nothing


 

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads