AdamC Member

@nmizzell @DavidChurchman Thanks guys I really appreciate the insight and both routes. Going to do some research down those paths and see what we can come up with. Appreciate it!

@nmizzell I also see there is some data science tiles in ETL like clustering I have never used before. I might look into that.

@nmizzell I think if I can output it in tabular data first that would be a big win and then as a team we can play with how they would like to see it best so maybe something like this for the first step. More thoughtful of how to get the data I want at the moment rather than the visual. I added some columns to the right…

@nmizzell This is what my data looks like. A couple hundred more columns, but basically this is the layout and what it looks like.

Thanks much. Boy that is for sure finicky, but sure appreciate the help. I don't know much about coding at all so took me a while to figure out what is going on. Thanks @MarkSnodgrass @Jmoreno appreciate the help! For anyone coming into the thread later down the road like me who is not great at coding this is what I ended…

@MarkSnodgrass Post from a while back, but I am trying to do the same thing essentially. I am connecting several sheets and there are a lot of overlap between column names. I'd like to add a prefix to each column header so I know which sheet it came from. So something like column 'date' for each sheet would have A_Date, B_…

Second what Mark said. Also, for problem solving. I'd take a small sample of the ones that didn't join and compare them between the two tables. Will probably find what Mark said and there are some leading or trailing blank spaces or case sensitivity.

Thanks all. I haven't tried variable so I will run down that rabbit trail and see what I can come up with. Appreciate your help and insight. I think I need to understand variables before I can fully grasp the suggestions on how to work it. Thanks!

Thanks I have only done a recursive data flow once and I am not sure it worked 100%. Had wondered if that was the path I needed to go down, but will go down that road then. Follow-up question: I think one problem I might run into is the team right now is only imputing missing data. I would need somehow to push that data…

Now that I spelled it out like that... I wonder maybe since the one sheet is a single date and the other is multiple. Maybe I can/should take the one sheet and narrow it down with an ETL to the single date and then join the tables after that so it would only have to choose between two dates?

Morning Grant. Thanks for the reply. I have read quite a few other problems you have helped solve for folks that have helped me on other things. Appreciate you taking the time. Each unit would have a unique ID. But to complicate things more, one of the sheets would have a unique and only one status and the other sheet has…

I wonder if you might be able to help me out with the syntax? I don't have a lot of background with any type of coding so starting with a blank slate.

Well what in the world... I tried to do that same thing here a few times the other day and couldn't get it to work. I must have had some of the column names in the wrong places. But that worked perfectly. Thanks much!!

Yep from what I am seeing I bet that's exactly what it is. Thanks Michelle, super helpful!

Thanks Rob. That worked the first go round. I think I will play with a bit and try to add some other things just to get more familiar, but that really helped me over the hump. Jae - thanks for that. I didn't realize that about mySQL so if I do some learning I will head that direction. Thanks again!