วีดีโอ

But Excel can't load the huge file to clean it there🥲

It appear this (20:56:49 load data infile 'freight.csv' into table freight fields terminated by',' ignore 1 lines Error Code: 1292. Incorrect date value: '2018-01-02;10975;38;774571;MMA-5946;Herrings Crossroads;7' for column 'fecha' at row 1 0.000 sec )

I am getting an Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement. pls help

Thank you for this. This is helpful. However, I have been having error 1050. Table hotel_bookings already exists

Thanks!!! the form of the videos and the step by step are really nice!!!

Error Code: 1292. Incorrect date value: '2020' for column 'date_added' at row 1 I still keep getting this error even thought I updated my data dates from yyyy-mm-dd

Help me out where the txt file will be saved

Where the file will be stored

Where the file will be saved

Assalamu alaikum, Mashallah youssef brother love from India, please make more dashboard like this❤❤❤

Is program file same as program data?

The changes can't be saved as it is saying that we you dont have permission for that please help to solve my problem

I can't find that file MY

HELLO i HAVE TRIED YOUR STEP BUT THEY ARE GIVING ME THIS ERROR: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

nicee

how can I edit tha datas within the table?

I am surprised that Tableau does not offer this slicer option. Your video is excellent though.

Thank you so much, you solved my problem !!!!

I'm facing issue while importing CSV file but there is an error that it's is not accepting character like $€¥°^®© these are the charector is not accepting and showing error

Tableau is pretty great but this is ridiculous lol

Still having issues. My dataset does has lot of null values and its not a calculated field you can easily apply formula. How do I import this file with the nulls

That's crazy. In powerBI, you just add a filter button OMG.

But it is showing error saying server is running with secure server file priv option. What shld i do

Hey I am getting error while importing " the MySQL server is running with the -secure-file-priv option so it cannot execute this statement

bro i want to import csv file containing 60000 rows into wix but there is a limit of 50,000 rows so i am trying to upload it to mysql(external database option) how do i achieve this?

its showing u dont have permission to open this file

Buddy, thank u so much for this video. I got a problem trying to resolve the secure-fiele-priv issue, but I read your comments and I could resolve it. THANKS A LOT.

Excellent.

as a data analyst,it’s possible that just import all excel data to mysql and query data as we need without learning excel ?

Is it possible to import data from excel to MYSQL on regularly ?

not all the dashboard is sales basis what if for asset management? that is why that profit margin does not apply always, please make an example that is generic to all

I have a question. I have a bar chart, showing the percentage of A from B. I want the bar to be green if it meets the target (constant), and red if not. Now, I've created the color calculated field, saying if percentage was higher than target then 1, else 0. But when I'm adding the field to color, it only shows 1 or 0. Not both so that I be able to set the colors. I do not know what is the problem. I did add other fields, thought maybe it's because it's a one bar, but again, I do not get both values, only then one which applies to the condition. Appreciate your help in this regard.

What if mysql server is not on local computer? I keep getting the error: "Access denied for user..."

Good one, but this is possible only when all dashboards are in same file, what if all dashboards are in different locations and files, what tool needs to be used??

Why am i getting "OS errno 2 no such file found"? I deleted the secur-priv and saved csv in the correct schema i want it to upload. ahhhhhhhhhhhh

Everything went well until the last step. While trying to execute load data I file step, getting error code 1290. Can anyone please help me with it.

Explore more Tableau Tips here: th-cam.com/play/PLkKXgGjnuuRYPqA7gsmyzOjlMy-S6BZfC.html&si=4a5SXeCDpGYASK-S

Explore more Tableau Tips here: th-cam.com/play/PLkKXgGjnuuRYPqA7gsmyzOjlMy-S6BZfC.html&si=4a5SXeCDpGYASK-S

Explore more on MYSQL CSV import: 1) using python and pandas (th-cam.com/video/5IU7PZZ0LM8/w-d-xo.htmlsi=ayhprBcnipS8-RJM) 2) using table data import wizard (th-cam.com/video/pmLrjtnUEBc/w-d-xo.htmlsi=a4C2Mxb0UaAEajBk) Find Error 1290 "secure-file-priv error" solution here (th-cam.com/users/shortsn4xjOUnfOMY?si=2ACk_9oOw0WfStyr)

This is so helpful, thank you so much. God bless you.

my program isn't run in sql

This is insane that we have to go through these lengths to create a filter button.

2 IMPORTANT ISSUES: 1) You start showing that your CSV is already loaded in Excel, but what if it is in a different format? How to save it as a CSV making sure that data is changed properly? 2) What if I can't open the CSV cause it is heavy? How to load and change the DATE FORMAT without using excel ?????

how do you make sure the line ends at the outer parts?

1.5 GB csv? Is this the way?

I have gone through all the steps, it's not returning an error, just '0 rows affected' I've done everything.

Thanakxx

Thank you for this video but I am getting this error when I am saving that file in mysql data folder " you don't have permission to save in this location contact the administrator to obtain permission" How to resolve this issue

@Data Analytics - Thanks for sharing it. I tried it and its working for first time and second time its throwing error "'tuple' object is not callable" Can you please help?

Wonderful work thank you so much !!!!!