Selecting the columns coming after a specific value in a cell

[Gandalf_NotGrey]

Hi

I have a table where I have to select the columns coming after the text "Set B". This can be present in any column, and either in row 4, 5 or 6.

See image 2. In field F17, row 5, we have "Set B" written, my requirement is to select all the columns starting from F17, which is where "Set B" is written. F17 to F33.

Similarly, in image 3, the text "Set B" is in field F8 and in 4th row, so all the columns on and after F8 are needed. F8 to F33.

Is there any way to do this dynamically?? I have attached a sample file as well.

Also, sometimes the data, which is there in the excel file, comes in e notation when pulled into Alteryx, I don't want that to happen and get the data only in decimals without the e notation.

[flying008]

Hi, @Gandalf_NotGrey 

Due to security policy restrictions, I am unable to upload. yx * files. Therefore, please refer to the annotations in the animation for all settings or formulas.

[PangHC]

@flying008 did it still restriction on if you open the workflow in notepad and paste the text here. 🤣 

[Gandalf_NotGrey]

Hello @flying008 Can you please share the configuration screenshots for the Multi-Row Formula, Dynamic Rename and Dynamic Select tools.

[goatley1]

[Gandalf_NotGrey]

Thank You so much @goatley1 @flying008 @binuacs for your responses. This was very helpful.

I was able to apply @goatley1 's solution and it worked perfectly. 

@binuacs - I was not able to resolve the error that was coming and due to security issues, I could not share the exact workflow. I really liked your approach though.

@flying008 - I could not see the configuration screens of the Multi-Row Formula, Dynamic Rename and Dynamic Select tools, so I was not able to try your solution. Appreciate your kind efforts for this.

Thank you all for your assistance on this.