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.
The question still puzzles me. If you were to take the data into a SAMPLE tool and get the 1st record out, you could append that value to all records (APPEND FIELDS). I'm fairly certain that the multi-row formula is where you will land. If you know that the field can't be NULL, you can check for isnull() of the row-1 and know that you're on the 1st record without an ID.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
I have attached a workflow of what I am trying to achieve. I get data that looks like this - Row 1 contains the Date (C1) & Time (C2) the data was exported. The real data is row 5+ for columns 2 & 3 with headers in Row 4
I want to remove the unnecessary cells and generate a DateTime stamp of each record.
I have done my Method (#1) and your method (#2). Both give the desired (& same) outcome
My original question for Method 1 was - can I remove the need for the Record ID tool by being able to reference Record # in the Multi-Row formula tool. As I said to @ddiesel, I am only chasing a 1% efficiency gain
Not totally positive on this, but I don't think there would be an efficiency gained... The Record Number is not actually data but rather a visual aid in the results tab of the program, similar to the record number when running a query in Microsoft SQL Server Management Studio. If you were able to access it like a piece of data Alteryx would have to run the same process as the Record ID tool at the beginning of every workflow, even those that do not use/need a Record ID tool. Thus causing a efficiency decrease for all workflows not needing this column. Which is why they have the Record ID tool, so that you can create the column when needed.