Discussions

Hi Team, Is there a option in Alteryx Designer Cloud to fetch username (user Login ID, email, ...) when one runs the workflow. I need this to maintain a run Logs. Thanks ... Mehr anzeigen

Hi Team,   I have a value in below format but when I am using the SELECT tool to double the value, it gives us a result like 14,1 " mean giving a value before comma. can you please guide.   14,131.81 1,721.31   Regards, Mahesh ... Mehr anzeigen

Hello everyone,   I am having issues with the data format in Alteryx. In my input, numbers are formatted like 642.200,19. I need to perform calculations in Alteryx, so I have to convert the column, which appears as a string in the input, to double.   Is there a more efficient way than using replace formulas to switch the format to the American style, remove thousand separators, and then convert to double? And does anyone know a quick method to insert thousand separators (as a period) into a number like, for example, 642200,19?   It should be done for an entire column in the correct format, where the column contains values of varying magnitudes (for example, those that require two thousand separators as well).   I appreciate any help you can offer—thank you!   Best regards, Kim ... Mehr anzeigen

Hi SME,   I have two sets of data that when joined using the Class_A_ID/Class_B_ID, the Amt (B) tied to Class_B_ID would be repeated to match up with the Amt (A) from Class_A_ID, as shown in the Data tab in the attached file.  What I want to get is the Result tab, where if Amt (B) is repeated within Class_A_ID or Class_B_ID (doesn't matter.  Columns I/J on the Result tab is my approach to get this work by using the Tile tool.  However, when I used the Tile tool, I only got column J to materialize - couldn't get both so that I can use the Multi-Row Formula tool to get what I need.   Any suggestions on how I can do this?   Thanks, kwl ... Mehr anzeigen

Hi SME,   I have two sets of data shown in the RAW DATA tab in the attached file. The RESULT tab is what I want to see when I stack the two sets of data next to each other.  I couldn't get the line up by matching classes and years using the Join by Record Position in the Join tool. If I tried to do this using the Join by Specific Fields with Class and Year, I would get duplicate values for Class B.   Any suggestions on how I can stack the two datasets to get the RESULT tab?   Thanks, kwl ... Mehr anzeigen