I just upgraded to a paid plan. I am running an AI education company and wanted to showcase Julius workflow feature but it seems to fail the most basic things of adding two files and removing duplicates. Customer service has not replied, so maybe someone here can tell me what I am doing wrong.
Here is the workflow:
Here is my test:
It seems I am only allowed two links in total in this forum so I cant add the link to the two google sheets in this post, but I commented below with the Google Sheets
Thanks for sharing. Iāll try taking a look at it and see what I can do with it. You just want the data from both sheets to be combined? Iām wondering if itās having issues with the mismatch in row numbers as well. Let me see what I can do.
Hi. Thanks for your help! The use case is to detect and delete duplicates. In the second file, there are 4 lines that are exactly the same as in the first file. I want Julius to combine the files, check for duplicates, delete the dupicates. So quite a simple task I would think.
For some reason itās not liking the google sheets, so I converted the files to .xlxs or .csv and that helped. Iām just currently testing it out step by step in the chat. Iāll keep you updated.
So sorry for missing your email. @chrisdavis92 thanks for also helping out on this as well.
Iām going to also take a look at it and see what I can do. Iām positive we can figure out a nice workflow for this for you to demonstrate at your company.
Yeah, I noticed that too but I just kind of left it as is. Mortiz, when you get the chance could you try out this workflow: Julius AI | Your AI Data Analyst? Let me know if the link works or not. You can also find the workflow by going to Explore workflow and then typing in āAnalyze and Deduplicate Excel Filesā. It should come up.
No, Iām an idiot. Thanks for pointing this out. I checked the top part of the file for what chat gpt generated, but failed to see that there are duplicates in the same file on the bottom. This explains my problem. As ususal, the problem is in front of the screen most of the time. Thank you so much for helping and checking this out for me. Highly appreciated!
Hi Alysha, when I click on the link, I just get to an empty page on Julius somehow. But I think the issue could have been solved by Chris who kindly checked my file and realized that in the lower section of the first file, there is duplicates already in the same file. So ChatGPT created duplicates in the first file and I did not see that. So 100% my fault Thanks so much for taking the time to help me, I really appreciate that!
Of course, Iām here to help! Itās always good to have a fresh pair of eyes to look at a dataset and Iām glad we got it solved!
Okay, Iāll report the sharing link issue to the engineers. If you start typing āanalyze andā¦ā in the Explore workflows section, youāll get a couple of results like this:
Itās the first one named āAnalyzed and Deduplicateā¦ā. Let me know if you see it! Also let me know if you can run it smoothly.
Thanks again @chrisdavis92 for the additional help!
Nah, sometimes when you stare at data for a long time you just miss things. Happens to us all (did the exact same thing last week when I was working on a dataset). Thatās why itās great to have a fresh pair of eyes to look at it.