Пікірлер
@kalpasaraswat663
@kalpasaraswat663 5 күн бұрын
my calculated fields are not showing in measure values but instead under measure names. Help to fix it
@maxchergik2439
@maxchergik2439 11 күн бұрын
You know you can insert automatically into MySQL all data straight from python, right?
@jakobpirs1392
@jakobpirs1392 7 күн бұрын
how?
@indianfacts1936
@indianfacts1936 18 күн бұрын
thanks of lot ...i have no words for you but such as you are a great man...this error have taken my a lot of time but after seen your video my all problem was solved as clear cut to cut ...once again thanks of lot...🙌🙌❤❤
@sandeepanand3834
@sandeepanand3834 25 күн бұрын
how to insert dataframe directly into mysql without manual pasting?
@gaurabparajuli3643
@gaurabparajuli3643 25 күн бұрын
wow
@DerLucht
@DerLucht Ай бұрын
You have no idea how grateful I am. I've tried everything, and nothing worked, and OMG this was a great solution! A tip for ppl with the same problem: ProgramData may be a hidden folder, so you may have to change the properties settings to see it. And also, instead of changing the file, you can just copy your table data file into the Uploads folder, and it will all be the same :)
@mayadisilalahixipmia-1657
@mayadisilalahixipmia-1657 Ай бұрын
but how to limit the number of rows i'm want to import? (in this case, i jusr want to import the first 1000 lines)
@ramu000009
@ramu000009 Ай бұрын
But the chart is not showing the 9.51% as the text!!!!!
@Emotion-od8ob
@Emotion-od8ob Ай бұрын
U got new subscriber 🎉
@Emotion-od8ob
@Emotion-od8ob Ай бұрын
Omg thank you so much have seen many vedios but nothing workes. U just saved me thank you thank
@A-museDesign
@A-museDesign 2 ай бұрын
Is there anyway to do this with less than 12 months of data? I can not do this and I think it might be because my data set has dates that don't total a full year.
@EuTomcosta
@EuTomcosta 2 ай бұрын
👏👏👏👏
@MissP3224
@MissP3224 3 ай бұрын
But Excel can't load the huge file to clean it there🥲
@jurgenklismannbolivarromer9051
@jurgenklismannbolivarromer9051 3 ай бұрын
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 )
@bhavya.76
@bhavya.76 3 ай бұрын
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
@indykoncepts2878
@indykoncepts2878 3 ай бұрын
Thank you for this. This is helpful. However, I have been having error 1050. Table hotel_bookings already exists
@huguititi
@huguititi 4 ай бұрын
Thanks!!! the form of the videos and the step by step are really nice!!!
@frederickjabagat6765
@frederickjabagat6765 4 ай бұрын
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
@tholetivamsidharreddy6261
@tholetivamsidharreddy6261 4 ай бұрын
Help me out where the txt file will be saved
@tholetivamsidharreddy6261
@tholetivamsidharreddy6261 4 ай бұрын
Where the file will be stored
@tholetivamsidharreddy6261
@tholetivamsidharreddy6261 4 ай бұрын
Where the file will be saved
@mohdhammad241
@mohdhammad241 4 ай бұрын
Assalamu alaikum, Mashallah youssef brother love from India, please make more dashboard like this❤❤❤
@rinchendorji94
@rinchendorji94 4 ай бұрын
Is program file same as program data?
@shubhangibajpai8716
@shubhangibajpai8716 5 ай бұрын
The changes can't be saved as it is saying that we you dont have permission for that please help to solve my problem
@ErwanKow-er2kf
@ErwanKow-er2kf 4 ай бұрын
Right click the file and go to the file's "Properties", then Security and chek "Full control"
@mouryaadey5863
@mouryaadey5863 5 ай бұрын
I can't find that file MY
@ND-lf3rg
@ND-lf3rg 5 ай бұрын
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
@pravashpinku8106
@pravashpinku8106 5 ай бұрын
nicee
@markjustinsayson7595
@markjustinsayson7595 5 ай бұрын
how can I edit tha datas within the table?
@JohnTittel
@JohnTittel 6 ай бұрын
I am surprised that Tableau does not offer this slicer option. Your video is excellent though.
@marcopecorale2221
@marcopecorale2221 6 ай бұрын
Thank you so much, you solved my problem !!!!
@Ankit_sharma24
@Ankit_sharma24 6 ай бұрын
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
@dude4173
@dude4173 6 ай бұрын
Tableau is pretty great but this is ridiculous lol
@asuquobassey1202
@asuquobassey1202 6 ай бұрын
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
@opal-r2h
@opal-r2h 6 ай бұрын
That's crazy. In powerBI, you just add a filter button OMG.
@sunidhibhat1342
@sunidhibhat1342 6 ай бұрын
But it is showing error saying server is running with secure server file priv option. What shld i do
@AnalyticsExplorers
@AnalyticsExplorers 6 ай бұрын
Hi there, Go watch this short video and I hope it will help kzbin.infon4xjOUnfOMY?si=qr6LFLij2jNRsBh2 Good luck!
@Sprinkle-ru3eb
@Sprinkle-ru3eb 7 ай бұрын
Hey I am getting error while importing " the MySQL server is running with the -secure-file-priv option so it cannot execute this statement
@Sprinkle-ru3eb
@Sprinkle-ru3eb 7 ай бұрын
Help me
@AnalyticsExplorers
@AnalyticsExplorers 7 ай бұрын
@@Sprinkle-ru3eb Hello, You can find your problem solution in this short video kzbin.infon4xjOUnfOMY?si=3jVUpEcwlGMheR-w Best of luck!
@sanikasunil5440
@sanikasunil5440 7 ай бұрын
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?
@shaikasma6014
@shaikasma6014 7 ай бұрын
its showing u dont have permission to open this file
@sergiotorres513
@sergiotorres513 7 ай бұрын
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.
@AnalyticsExplorers
@AnalyticsExplorers 7 ай бұрын
Grateful that my video helped you!🙏
@Magistrado1914
@Magistrado1914 7 ай бұрын
Excellent.
@AnalyticsExplorers
@AnalyticsExplorers 7 ай бұрын
Thank you for your feedback🙏
@dezinhtang
@dezinhtang 7 ай бұрын
as a data analyst,it’s possible that just import all excel data to mysql and query data as we need without learning excel ?
@ashutoshkumartiwari3209
@ashutoshkumartiwari3209 7 ай бұрын
Is it possible to import data from excel to MYSQL on regularly ?
@jiancarlochua5346
@jiancarlochua5346 7 ай бұрын
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
@artmisbabaei5659
@artmisbabaei5659 8 ай бұрын
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.
@AnalyticsExplorers
@AnalyticsExplorers 8 ай бұрын
Hi there, Hope you're doing well. This approach is not suitable for your case as tableau shows only the available values only for the field you created. So, if your calculated field has all values of 1 then tableau will show 1 in the color field unlike this video where we have both values (0,1) in the fields values.
@artmisbabaei5659
@artmisbabaei5659 8 ай бұрын
@@AnalyticsExplorers Hello, thank you for taking the time. May I ask if you have any suggestions for what I need to do?
@louisocarroll
@louisocarroll 8 ай бұрын
What if mysql server is not on local computer? I keep getting the error: "Access denied for user..."
@ManjeetKaurSardar
@ManjeetKaurSardar 8 ай бұрын
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??
@johnvak7390
@johnvak7390 8 ай бұрын
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
@AnalyticsExplorers
@AnalyticsExplorers 8 ай бұрын
Did you put your csv file in the correct directory?
@johnvak7390
@johnvak7390 8 ай бұрын
I think so. Program data - Mysql - mysql server 8.0 - data -tablename - table@@AnalyticsExplorers
@johnvak7390
@johnvak7390 3 ай бұрын
@@AnalyticsExplorers I forgot what I did; it's been a while, but it's fixed. Thanks for creating this video as my company has transitioned from ms access to an actualy rdbms
@suvarna625
@suvarna625 8 ай бұрын
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.
@AnalyticsExplorers
@AnalyticsExplorers 8 ай бұрын
Hello Suvarna, You can find the solution in our short video here: kzbin.infon4xjOUnfOMY?si=rj1MxuCMHAI9lpQ5 Good luck and if you find it useful, don't forget to spread it with your colleagues!😀
@AnalyticsExplorers
@AnalyticsExplorers 9 ай бұрын
Explore more Tableau Tips here: kzbin.info/aero/PLkKXgGjnuuRYPqA7gsmyzOjlMy-S6BZfC&si=4a5SXeCDpGYASK-S
@AnalyticsExplorers
@AnalyticsExplorers 9 ай бұрын
Explore more Tableau Tips here: kzbin.info/aero/PLkKXgGjnuuRYPqA7gsmyzOjlMy-S6BZfC&si=4a5SXeCDpGYASK-S