topic Re: Unable to make Business Rule Analysis in Talend Studio

Unable to make Business Rule Analysis

Anonymous — Thu, 22 Feb 2018 14:38:18 GMT

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!

Re: Unable to make Business Rule Analysis

manodwhb — Fri, 23 Feb 2018 05:20:57 GMT

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

Re: Unable to make Business Rule Analysis

manodwhb — Fri, 23 Feb 2018 09:07:02 GMT

Did it help you?

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

Re: Unable to make Business Rule Analysis

Anonymous — Fri, 23 Feb 2018 13:37:20 GMT

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?

Re: Unable to make Business Rule Analysis

manodwhb — Mon, 26 Feb 2018 04:22:01 GMT

what is the DB type and do you have permession to get the table for the user,which you are using?

Re: Unable to make Business Rule Analysis

Anonymous — Mon, 26 Feb 2018 17:46:41 GMT

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

Re: Unable to make Business Rule Analysis

manodwhb — Tue, 27 Feb 2018 04:55:09 GMT

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

Re: Unable to make Business Rule Analysis

Anonymous — Tue, 27 Feb 2018 16:26:19 GMT

Still get the same error..

Re: Unable to make Business Rule Analysis

manodwhb — Wed, 28 Feb 2018 04:12:57 GMT

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

Re: Unable to make Business Rule Analysis

Anonymous — Thu, 01 Mar 2018 13:40:21 GMT

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

Error.PNG
Selection.PNG
Single_Analysis.PNG
Single.PNG
Imported.PNG

Re: Unable to make Business Rule Analysis

manodwhb — Fri, 02 Mar 2018 09:20:19 GMT

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.

Re: Unable to make Business Rule Analysis

manodwhb — Mon, 05 Mar 2018 06:52:43 GMT

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

Re: Unable to make Business Rule Analysis

Anonymous — Mon, 05 Mar 2018 15:23:37 GMT

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

Error_Right.PNG

Re: Unable to make Business Rule Analysis

manodwhb — Mon, 05 Mar 2018 16:04:18 GMT

Can you check the Columns check box and show me?

Re: Unable to make Business Rule Analysis

Anonymous — Mon, 05 Mar 2018 16:15:42 GMT

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

Re: Unable to make Business Rule Analysis

manodwhb — Tue, 06 Mar 2018 04:18:01 GMT

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?

Re: Unable to make Business Rule Analysis

Anonymous — Tue, 06 Mar 2018 14:40:23 GMT

I can't share the Excel 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..

Error.PNG

Re: Unable to make Business Rule Analysis

manodwhb — Tue, 06 Mar 2018 14:45:29 GMT

Can you check the file has not corrupted?

Re: Unable to make Business Rule Analysis

Anonymous — Tue, 06 Mar 2018 14:47:38 GMT

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

Re: Unable to make Business Rule Analysis

Anonymous — Thu, 22 Mar 2018 16:47:39 GMT

Still Nothing