This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi guys! I'm new here and I'm having a strange issue that I could not manage to fix and I wanted to know if anyone of you have ever had this problem. I have my dataset, which contains multiple rows for client_id, and a summarize dataset grouping by client_id to do some calculations like shipment costand etc. I used the Join Tool to join them and create a new column with repeated shipment cost values to each row of client_id and it worked perfectly for what I wanted to do. But here is the problem: when I uploaded my dataset to Powerbi and did a double check on it, my distinctcount of rows was not the same as my distinctcount of rows on the original database (from excel). It was something like 1355 x 1480. So I started to look for one of these missing 125 client_ids on my Alteryx flow, and it did not appear in the flow after the join with summarize part. So I went to check out individually on the two datasets that I used in the Jointool: my original one and the summarized one. For my surprise, the client_id was in both of them, but did not appear in the "J" of the Join Tool. I thought that maybe it had a blankspace or something like that, but in this case it would have appeared on the "L" or "R" from the Join Tool, which was not the case. My lines literally got removed and are not in any of the 3 outputs from the join tool. Anyone knows what to do in this scenario? Thank you in advance!
Hi Joe. Yes, I have a browse tool and the number I'm looking for can be found there. The problem is right after the Join, he doesnt show up in any of the three outputs from the join tool (L, R or J) and that's why I cant find him on my final output that I've exported to PowerBI despite the fact that he is on my input dataset.
Hi dan! What filter would you recommend me to use? I'm having trouble to do that because there isnt any apparent difference between the field on my main data set and the summarize output. They are literally the same (with the same numbers of characters, without blank spaces, commas and etc) because they come from the same dataset (the main one)