Participate

vivian123

Hi all, I am using the join tool to combine data however I seem to lose data after joining. I would like to join these 2 tables based on PetID. Table 1: OwnerID Number of pets PetID Weight 123 2 111 10 123 2 222 20 234 1 444 40 567 1 555 Table 2: PetID Weight Length 111 10 50 222 20 60 444 40 70 Ultimately, I want the end product to look like this: OwnerID Number of pets PetID Weight Length 123 2 111 10 50 123 2 222 20 60 234 1 444 40 70 567 1 555 After using the join tool, I seem to lose the data for OwnerID 567. What's the correct way to do this? Thanks!

Phil

Hello Community, I'm trying to transform the data of one column of a table to headers and populate them with the corresponding data from another column, while keeping other information. I want to get from here: to here: Thank you very much for your help! Phil

jjg21

Hello Alteryx wizards! I am having a hard time figuring out what I am doing wrong with my RegEx function. I have what is essentially a UPC Code i.e. 0156483010299 For which I am attempting to parse as follows: [01564830] [1029] [9] 8 4 1 The current formula I used was: (\d{8})(\d{4})({\d{1}) which returns null values every time, but I found that if I only leave the first part of the equation (\d{8}) I get the desired result for the first 8. I've scrounged through the other similar topics and videos and have only come up with results where there is a space or text involved so im wondering if there may be something with how I'm combining the difference output columns. Appreciate the guidance!

suby

Hi All, I have a sample Input Data and expected Output in the attached workflow. I want to the find difference in Months between the SECOND DATE & FIRST DATE and bucket it. Attached the sample workflow. Thanks.

Chris86

Hi, I am not well versed in API's and have always had a great difficulty working with them in the past. However, practice makes perfect...eventually. I am trying to connect to the Alteryx Admin API in an effort to download all workflows that were added/edited in the last three months. I am having an enormously difficult time following and adjusting the information from Using the Alteryx API from….Alteryx. It appears at a high level that this is what I am needing to do but I am not sure if this is significantly more complex than what I need it to do. Is there a way, with the download tool to access the Alteryx Admin API and download all the workflows in the last three months? Ultimately, I will use a macro that will scan through each of the workflows and output what tools are being used and the frequency of said tools. Any help on this would be wonderful.

Participate

Community Hub

Discussions

Ideas

Alteryx For Good

Alteryx Advocacy

Beta Program

ACE Program

Category Activity

join tool - lost data

Transform 1 Column to Row Headers and populate with values from separate column

Parse fixed width - Number

Dates ?

Alteryx Admin API Connection to Download All Workflows